Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find a Match in Multiple Places & Return Multiple Values | Excel Worksheet Functions | |||
find values in multiple cells and paste row values | Excel Discussion (Misc queries) | |||
Find and return multiple values | Excel Worksheet Functions | |||
find multiple occurances of a value and match to values in another | Excel Discussion (Misc queries) | |||
Find values from cells in multiple sheets | Excel Worksheet Functions |