I am trying to create a macro that will check within the currect selection for any cells that are blank. If they are blank I would like it to have an error message and maybe change the cell a yellow color. Right now I have a macro that will run before each save to select the cells that I need checked for blanks cells but I can get the other macro to work correctly.
The code that selects the cells I need checked.
Please Login or Register to view this content.
Last edited by Eamonn; 04-27-2011 at 02:30 PM.
Something like:
Please Login or Register to view this content.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
You can use the specialcells to identify the blank cells.
Please Login or Register to view this content.
Got it to work with both of your help!! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks