View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dok112[_5_] dok112[_5_] is offline
external usenet poster
 
Posts: 1
Default Multiple coloumns data

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