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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>