Excel 2010 VBA Scripting to start data on a new line
Posted on 2013-11-25
Hello, I am a newbie at VBA so please be gentile. I've created a userform in Excel 2010 to enter straight data into a worksheet where I will then use that to create reports. I've been able to create the script where once a record has been entered it goes to a new line:
nextrow = WorksheetFunction.CountA(Sheets("IM Raw Data").Range("A:A")) + 1
Now I'm stuck on creating the code that will start on a blank row once the spreadsheet is open. Any ideas?