View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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