going 3 columns over in a macro
Try replacing this:
Range("F834").Select
With this:
ActiveCell.Offset(0, 3).Select
Whatever cell you're in when the macro runs will determine where you end up.
If you're in A1 you'll end up in D1.
--
Biff
Microsoft Excel MVP
"ben" wrote in message
...
Hello,
I recorded a macro and have a small detail I need to fix, but am unsure
how to do it. At the end of the recording of the macro, I hit the right
arrow 3 times to move over 3 cells across. The problem is that the macro
recorded it as follows: Range("F834").Select
How do I change that line from an absolute reference to a relative one so
that the cell I am on is 3 to the right?
Thanks,
Ben
|