Hi Folks,
Below is a macro that highlights the blank cells in column E. It works great however I can't get it to stop when it reaches a blank row. The other option would be to stop the macro when column B or C no longer has any data. Either way, I can't quite figure it out. Any help would be appreciated.
Please Login or Register to view this content.
Last edited by JBeaucaire; 02-08-2013 at 07:04 PM. Reason: Added code tags, as per forum rules. Don't forget!
Please Login or Register to view this content.
Last edited by JBeaucaire; 02-08-2013 at 07:04 PM. Reason: Added code tags, as per forum rules. Don't forget!
Ben Van Johnson
I would have a try like this:Please Login or Register to view this content.
Last edited by rollis13; 02-11-2013 at 05:32 PM.
Hi, HappyLadyToo,
I like these lines:
AFAIR this will always look up Column AS and return the row of last used visible cell + 1 there - so why not check that column on itīs own instead of using a range that you donīt operate on (columns A to AR)?Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Wonderful Thanks!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks