Set rng = Columns(2).SpecialCells(xlConstants)
if rng.Areas.count 2 then exit sub
i = 0
for each ar in rng.Areas
i = i + 1
if i = 1 then
macro1 ar
else
macro2 ar
end if
Next

However, if you colored them, you should be able to identify where to start

Why not post under a single Name.

--
Regards,
Tom Ogilvy


"dok112 " wrote in message
...
I am not sure if this is possible or not, probably is, but i'm still a
beginner in the world of macros. Gotta love your bosses!!
What I'm trying to do, is take a productivity report, and color code
the different values. I already have the macro written for this,
however, my problem lays within the coloumns themselves. In one
coloumn I have two sets of data, that I want to run two macros on.
(ie. Macro1 for B1:B8 & Macro2 for B10:B15). The data for Macro1 will
not always be B1:B8. It varies from day to day. The last data input
though is always automatically color coded light yellow. And the
second set of data always begins 2 cells below the last cell of the
previous.

So my question is, can I create a macro that will run Macro1 on cells
B1:B(light yellow) and Macro2 on cells B(light yellow + 2 cells):B?

If it's possible and someone can help me out I will be most
appreciative. THANKS!!! :)


---
Message posted from http://www.ExcelForum.com/