Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thank you, Anders.
I still got an error after this change (but it got thrown in the function, not the sub). I fiddled around and eventually added 'set' to the assignments in both the calling sub and the function and was able to get it to work properly. Can anyone explain why I need to use: Set findColorInRange = resultrange // from function and Set rng = findColorInRange(range("database"), 38) // from calling sub I guess I've been clear on when to use 'set" and when not to... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lock cells based on interior color | Excel Discussion (Misc queries) | |||
Range: changing interior color | Excel Programming | |||
color the interior of a range | Excel Worksheet Functions | |||
Interior color based on dates | Excel Programming | |||
Find range by interior color | Excel Programming |