Macros - stepping left in a macro

  • Thread starter Thread starter Rich H.
  • Start date Start date
R

Rich H.

Unlike what I remember of Lotus or Quattro macros, when I
record in Excel a keyboard move to the left (or right)
picks up the cell number, not the number of steps. I
need to go to a named point, insert a column, move left
twice, then fill a date one step to the right (basically
to add a new date column). By doing this I hope to
expand the range for sorting and printing purposes. But
nothing seems to work as I expect.
How do I use named ranges in macro?
How do I go to a point and step in any direction?
How do I fill a date one cell to the right?
 
Rich,

Try something like the following:

Range("TheName").Select ' go to 'TheName'
Selection.Offset(0,-2).Select ' move two cells left

See Offset in VBA Help for more details.
 
Back
Top