I also want that cell, say J1, to be in the top left corner. What else do I
need?

Thx

"Tom Ogilvy" wrote in message
...
If you want a certain cell selected

Sheet("Resource Hours").Select
Range("D1").Select

--
Regards,
Tom Ogilvy

"Grace" wrote in message
...
When my macro is done, I would like it to show certain columns of a
sheet.
When I record the keystrokes to do this, it looks fine. But when the
macro
runs automatically, it ends up a few columns over. Her is the code I
recorded. What variable could be messing me up ( I think I may have
clicked
relative references when I recorded the macro)?

Sheets("Resource Hours").Select
Application.Goto Reference:="R1C1"
ActiveCell.Next.Activate
ActiveCell.Next.Activate
ActiveCell.Next.Activate

Thanks
Dean