A basic Macro: going to a particular Worksheet and then selecting
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!
|