I am not sure if this is possible or not, probably is, but i'm still
beginner in the world of macros. Gotta love your bosses!!
What I'm trying to do, is take a productivity report, and color cod
the different values. I already have the macro written for this
however, my problem lays within the coloumns themselves. In on
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 wil
not always be B1:B8. It varies from day to day. The last data inpu
though is always automatically color coded light yellow. And th
second set of data always begins 2 cells below the last cell of th
previous.
So my question is, can I create a macro that will run Macro1 on cell
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 mos
appreciative. THANKS!!! :
--
Message posted from
http://www.ExcelForum.com