Finding first empty row in database problem

[seanturner9005]

Hi All,

I am using code to find the first empty row in a database, but at the bottom of my sheet i have a sub-total auto sum. This means when I put data into the sheet using the userform, it puts the data below this. I think i need a different code that i can assign the first row where i want the data to go and then fill down from there.

Fairly new to VBA and userforms so apologies if this is easy.

Here is the code im using at the moment

Please Login or Register  to view this content.

Many thanks for letting me waste your time in advance

Sean

[patel45]

attach a sample file to understand better