LinkBack URL
About LinkBacks
Hi,
I would like code to go to go through all rows in a worksheet starting from row 2. Find the last cell used in this row & then colour the next cell after this (next right cell) cell to red
Do this loop until it value in column a is null/""
Cheers
Hi,
I would like code to go to go through all rows in a worksheet starting from row 2. Find the last cell used in this row & then colour the next cell after this (next right cell) cell to red
Do this loop until it value in column a is null/""
Cheers
Last edited by pr4t3ek; 02-24-2010 at 02:28 AM.
--
Regards
PD
----- Don't Forget -----
1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
2. Thank those who have helped you by Clicking the scales above each post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Hi.
See this link
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
link doesn't have it exactly, i can find the last cell i guess, but how can i add one to it?
What about this one?
Please Login or Register to view this content.
i want the colouring on the last cell of EACH row, not just the last row
no probs, got it
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks