Changing color

's Computer Specifications

hello

i need help creating a macro that reads values from one sheet and
high-lights all the rows where the values appear in another sheet.

I have no idea on how i go about doing this, plz help!

's Computer Specifications

Look at Find in VBA Help.

--
__________________________________
HTH

Bob

"Robin" <(E-Mail Removed)> wrote in message
news:87856347-9945-45CB-AAF2-(E-Mail Removed)...
> hello
>
> i need help creating a macro that reads values from one sheet and
> high-lights all the rows where the values appear in another sheet.
>
> I have no idea on how i go about doing this, plz help!

's Computer Specifications

erm sorry could u plz tell me where is VBA Help?

Thanks and Regards
Robin

"Bob Phillips" wrote:

> Look at Find in VBA Help.
>
> --
> __________________________________
> HTH
>
> Bob
>
> "Robin" <(E-Mail Removed)> wrote in message
> news:87856347-9945-45CB-AAF2-(E-Mail Removed)...
> > hello
> >
> > i need help creating a macro that reads values from one sheet and
> > high-lights all the rows where the values appear in another sheet.
> >
> > I have no idea on how i go about doing this, plz help!
>
>
>

's Computer Specifications

You are creating macros and you haven't discovered VBA Help?

F1 in the VBIDE.

--
__________________________________
HTH

Bob

"Robin" <(E-Mail Removed)> wrote in message
news:2D062B22-92D7-41C5-896A-(E-Mail Removed)...
> erm sorry could u plz tell me where is VBA Help?
>
> Thanks and Regards
> Robin
>
> "Bob Phillips" wrote:
>
>> Look at Find in VBA Help.
>>
>> --
>> __________________________________
>> HTH
>>
>> Bob
>>
>> "Robin" <(E-Mail Removed)> wrote in message
>> news:87856347-9945-45CB-AAF2-(E-Mail Removed)...
>> > hello
>> >
>> > i need help creating a macro that reads values from one sheet and
>> > high-lights all the rows where the values appear in another sheet.
>> >
>> > I have no idea on how i go about doing this, plz help!
>>
>>
>>

's Computer Specifications

thanks i found it :-)

"Bob Phillips" wrote:

> You are creating macros and you haven't discovered VBA Help?
>
> F1 in the VBIDE.
>
> --
> __________________________________
> HTH
>
> Bob
>
> "Robin" <(E-Mail Removed)> wrote in message
> news:2D062B22-92D7-41C5-896A-(E-Mail Removed)...
> > erm sorry could u plz tell me where is VBA Help?
> >
> > Thanks and Regards
> > Robin
> >
> > "Bob Phillips" wrote:
> >
> >> Look at Find in VBA Help.
> >>
> >> --
> >> __________________________________
> >> HTH
> >>
> >> Bob
> >>
> >> "Robin" <(E-Mail Removed)> wrote in message
> >> news:87856347-9945-45CB-AAF2-(E-Mail Removed)...
> >> > hello
> >> >
> >> > i need help creating a macro that reads values from one sheet and
> >> > high-lights all the rows where the values appear in another sheet.
> >> >
> >> > I have no idea on how i go about doing this, plz help!
> >>
> >>
> >>
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing text color and textbox color on Access Report	Cindy	Microsoft Access Reports	0	1st Dec 2010 05:15 PM
Can you vary the strikethrough color without changing text color	Linmark10	Microsoft Word Document Management	2	16th Dec 2008 12:22 AM
changing a color based on another color change	Steve	Microsoft Excel Programming	1	25th Nov 2008 12:05 PM
Changing color in color palette	Gilbert De Ceulaer	Microsoft Excel Setup	1	12th Dec 2004 02:39 PM
Changing Application color to follow Change of System Color	Toni	Microsoft Dot NET Framework Forms	2	11th May 2004 10:15 AM