Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Warn for an Empty Record
Hi all
I have the following: ColumnA Column B title1 data1 title2 title3 data2 title4 when i reach row five it runs a macro : before proceeding i want to check any empty cells in this range and should go back to that empty cell with a message this cell should be filled in my above eg: it should say title2 and title4 is emppty and select column B row 2 (Title2) My code now only says "There are empty cells" without specifically saying which are they and selecting the corresponding cell any help? TIA Soniya |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i get excel to warn me that i already used a certain value | Excel Discussion (Misc queries) | |||
warn me when text appears | Excel Worksheet Functions | |||
Warn if already entered | Excel Worksheet Functions | |||
Warn when a cell value has changed | Excel Worksheet Functions | |||
Warn if data is in range | Excel Worksheet Functions |