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?