I have just start using vba and I have a problem. I am using a user form to input data into a database with built in formulas. I am using modified code found on the internet which uses this line:
Rowcount = Worksheets("Orders Database").Range("A1").CurrentRegion.Rows.Count
to find the first empty row to input data. This however, factors in the built in formulas and inputs the data too far down the spreadsheet. How can I modify the code where it finds the first empty cell in say Column A then input the data in cells in that row.
Thanks
Rowcount = Worksheets("Orders Database").Range("A1").CurrentRegion.Rows.Count
to find the first empty row to input data. This however, factors in the built in formulas and inputs the data too far down the spreadsheet. How can I modify the code where it finds the first empty cell in say Column A then input the data in cells in that row.
Thanks