Hi All

I need some help with a macro to locate the first occurance of text i
a list so that I can then select that row and format it ie like a min
heading

Here's an example:

My range (a named range called WIP_Area) goes from A12:K12 and the
down, in column A there is a list of text that has the followin
categories: Incoming, Work in Progress, On Hold and Other. The rows ar
sorted so that each category is grouped. I want to locate the firs
occurance of each of these categories in column A (however a categor
may not appear at all), then select the range A:K for that row so tha
I can then apply a fill / shading to the range.

I am sure that this is quite simple when you know how

Any help would be appreciated

Thanks

KS

--
ks
-----------------------------------------------------------------------
ksp's Profile: http://www.excelforum.com/member.php...nfo&userid=626
View this thread: http://www.excelforum.com/showthread.php?threadid=55088