So, what is the exact bit you are having a problem with?
Maybe have a look at the posting: Row number of a specific value in this
same NG, posted today.

RBS

"Simon Lloyd"
wrote in message
...

Thanks for the reply RB i'm not trying to find a week (or sheet named
that week) in the array i want to search through the sheets in the
array looking for a date match to the one in combobox1 on my userform3
when it finds the match i need it to offset(1,x) and change colour lets
say to Red where x would be dependent on the name in the combobox2 e.g
offset(1,1) would be Lauren offset(1,2) would be Emma and offset(1,3)
would be Cheryl, then once they have had their holiday and the colour
change is older than one week turn the cell colour back to its original
colour (they are different for each girl), The dates appear only in
column A on each of the sheets in the places listed below:

Range("A1")
Range("A49")
Range("A97")
Range("A145")
Range("A193")

Any other ideas?

Regards,
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=557701