Hi All,
I have a spreadsheet which has multiple rows and columns. Now I want to throw one single error message for all blank cells before the last cell with value. Below is a sample table:
sun mon tue wed thur fri sat
Currently I have the the below macro which shows popup message for every blank cell before last cell:
Can any one please help me with these?
Please Login or Register to view this content.
Last edited by vlady; 11-23-2012 at 03:45 AM. Reason: code tags
Can you please explain the below line
before the last cell with value
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
In the table provided in the question you can see three cells are blank in between before the last cell with value, i.e. "fri" in column 1 and two cells are blank before "thur" . So I want to show a single message for all those blank cells.Originally Posted by :) Sixthsense :)
Ok understood... What would be the expected Message box text you would like to get?
Hey thnx for replying! the below text should be displayed:
"Please give inputs in sequentially. Cells cannot be empty in between."
Can you please give a code to accomplish this?
Please Login or Register to view this content.
Thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks