Find last row of A:A with data and stop
I have a while loop to color my rows down to row 2000 but all the time color way more than needed.
I like to change the while loop or replace with better code statement that will see last row of (A:A) that has data and stop there, then to keep color code rows to 2000.
Please Login or Register to view this content.
Last edited by MBCMDR; 11-11-2009 at 02:54 AM. Reason: Added full code
So, this isn't an Access question?
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Thread moved...
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Sorry I must have posted in wrong group as also doing an Access project but it doinmg much better than my excel macros LOL....
MB
I first posted in wrong fourm and this seem to have gotten lost because of me please see attached Sample of the color code.
Marco on Worksheet "TOOLS" and controls color on worksheet "BOM"
When you click the macro it color codes rows 3 - 2000 I just like it to color code the rows with data (A3:A) as each BOM project has its own parts kit and number of items.
MB
Figure it out fairly easy was over looking first idea..
Here the change I did in the macro
MBPlease Login or Register to view this content.
Last edited by MBCMDR; 11-11-2009 at 02:56 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks