Find next empty cell (Row)within a specific range in column A

Hi All,

New to VBA but learning fast

I have my excel spread sheet and have made a Userform so that certain Cells are filled by users when they fill out the form.

My problem is: i am trying to find the next free Cell in Column A and then fill the colums A, B and C in that row when the Save button is pressed.

I currently have the following:

Please Login or Register  to view this content.

This works to a degree, it finds the empty cell (after skipping 3 or 4 empty cells and fills everything ok.

I need it to search between A9:A30, find the next cell thats empty and fill column A, B and C. This should do this even if columns D:XXX are filled.

Any help would really be appreciated.

Regards

Jeremy

Try this.

Please Login or Register  to view this content.