View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
ben ben is offline
external usenet poster
 
Posts: 22
Default going 3 columns over in a macro

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