Find next empty row within range

[syedmehdi]

Hi all,

Just need the following code tweaking.

The following code allows me to find the next empty row so that I can use a userform to input data into sheet 1 using text boxes.

Please Login or Register  to view this content.

...however I would like to adjust the erow = line so that it finds the next empty row between a certain range (for instance, find the next empty row between row 5 to row 20 and then enter data from textboxes).

Thanks

[mehmetcik]

This finds the first blank below A5

Please Login or Register  to view this content.

You will need some code to deal with cases where the blank is after row 20

Please Login or Register  to view this content.

[syedmehdi]

Hi mehmetcik,

Thanks for the speedy response. I've adjusted my code to:

Please Login or Register  to view this content.

... but can't get it working. It's selecting the right place but not entering the data. Apologies if i'm being stupid (new to VBA).

I've attached my workbook if this helps demonstrate.

[mehmetcik]

You misunderstood me.

Please Login or Register  to view this content.

[syedmehdi]

Ah right, my bad.

Works like a charm. I just needed to change .select to .row to pull in the row number.

Thanks for your help