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!

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
"Mike C" wrote:

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!

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

Mike C wrote:

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!

--

Dave Peterson