Select Cell if Blank

[verse]

Hi,

I need a Script that will allow me to select a cell 'C18'
If C18 is not blank, move down to C19
If C19 is not blank, move down to C20
ETC until;
If C37 is not blank, [alert user] Please use a new order form!


Any help would be appreciated, I have tried many things and searched for quite some time, and have gotten, well no-where.

[sweep]

Hi,

Try this.

Please Login or Register  to view this content.

[DonkeyOte]

Alternatively, if you can assume C17 to never be blank (ie header) and C38 to always be blank... and that you don't have blanks interspersed ie C18 text, C19 blank, C20 text then you avoid looping along the lines of:

Please Login or Register  to view this content.

Another alternative - perhaps a little more robust:

Please Login or Register  to view this content.

[verse]

Appreciate your responses, it helped in learning more about the process; I managed to get what I wanted using this code

Please Login or Register  to view this content.

I would like to incorporate my error message if runtime error 1004 occurs, so something along these lines

Please Login or Register  to view this content.

Which doesn't work ... Could I pick your brains for another bit?

[jasoncw]

See if this works for you:

Please Login or Register  to view this content.

HTH

Jason