View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AccessHelp AccessHelp is offline
external usenet poster
 
Posts: 213
Default Checking Blank Rows

I have a range (A1:A50) where users type in the information. In the range
users not suppose to skip a cell(s) and type in the information in the cell
after. For example, I type in the info in Cell A1. Then I skip Cell A2 and
type in the info in Cell A3. In this example I am not supposed to skip A2
and type in the info in A3.

Can we write a code to check and prompt the users not to skip the cell(s)?
Please consider sometimes the users may skip more than one cell, and I only
want to check and prompt the users for the skip cells. The users may or may
not type in the info in all A1:A50. Therefore, the checking should stop on
the last cell of info entered.

Please help. Thanks.

Happy New Year to you all!!!