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