View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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!