A basic Macro: going to a particular Worksheet and then selecting thefirst blank cell in column A

[Mike C]

Hello all

Could someone please let me know what would be the code for simply
jumping to worksheet A (i.e., Sheet4, and then selecting (i.e.,
placing the cursor in) the first blank cell at the bottom of column
A.

Thanks!

 

[FSt1]

hi
worksheet A or sheet 4? no matter... replace with appropriate name if needed.

Sheets("A").Activate
'''''select from top down''''''''''
Range("A1").End(xlDown).Offset(1, 0).Select
'''''Select from top up'''''''''
Range("A65536").End(xlUp).Offset(1, 0).Select

regards
FSt1

 

[Dave Peterson]

Option Explicit
Sub Testme()
with worksheets("sheet9999")
application.goto .cells(.rows.count,"A").end(xlup).offset(1,0)
end with
End Sub