View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gene Augustin Gene Augustin is offline
external usenet poster
 
Posts: 36
Default Move selected range to left

I have a macro that selects a range of cells in a column that contains data.
I want to then offset that selection to the next column to the left, that
column has no data.
I tried:
Range(ActiveCell, ActiveCell.End(xlDown)).Select
ActiiveColumn.Offset(-1, 0).Select

The first command line selects the proper data range. The second line is
wrong.

Also, without using cell references, how do I select the topmost cell in a
column or leftmost cell in a row from a random location cell?

Is there an online reference for VBA commands?