Is there a simple way to check lots of cells for entries?
I have a worksheet that has rows 3 - 23 in input lines for the user. Not all
rows will be used. It depends on how many places the person has visited.
When the person goes to save the file I want to check to see if certain
columns have been filled in. If they have not then I want to open a message
box telling them to fill them in before saving.
My question is this. since not all rows will have entries I only want to
test the rows that have something in any of the columns A - AF
Is there a simple way to check this?
|