View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cue Cue is offline
external usenet poster
 
Posts: 47
Default Find Multiple Cell Values

For the following line:

whatwant = Sheets("300-+").Range("$A$65000").Value

It will only search for that cell value that is from Sheets "300-+" color
that value on sheet "MultAdjDaily". But instead of one value, I would like it
to search for multiple cells with values and color them on "MultAdjDaily". I
tried the following but it did not work:

whatwant = Sheets("300-+").Range("$A$65000:$A$65125").Value

I want the code to take the multiple cells with values that are on sheet
"300-+" and find them and color them on sheet "MultAdjDaily".

Can you show me what to change in order for that to work?

--
Cue