Hi I am a novice at vba. I am using Excel 2010. I have a workbook with 4 worksheets with sports results and I want the cursor to be left at the last row of data, at column A on each sheet. I found a piece of code to find the last row number:
Dim lastrow As Long
lastrow = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row
MsgBox lastrow
Produces the correct row number for one sheet. I am trying to use this to place the cursor but can't add the column name to it.
Can this even be done?
Dim lastrow As Long
lastrow = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row
MsgBox lastrow
Produces the correct row number for one sheet. I am trying to use this to place the cursor but can't add the column name to it.
Can this even be done?