Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IS BLANK checking 2 Cells | Excel Worksheet Functions | |||
checking for a blank field | Excel Programming | |||
Checking for blank rows in database - with apologies to Norman Jon | Excel Programming | |||
checking if worksheet is blank | Excel Programming | |||
Checking if worksheet is blank | Excel Programming |