going 3 columns over in a macro

  • Thread starter Thread starter ben
  • Start date Start date
B

ben

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
 
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.
 
As always, post your code for comments. It's almost always NOT necessary to
select a cell.
 
Don said:
As always, post your code for comments. It's almost always NOT necessary
to select a cell.
Click to expand...

I don't know what you mean since this would depend on what the user (me)
wants to do. After highlighting the data in one excel file, I do a special
paste with just the values of the highlighted region in another sheet (in
another file) where the cell it finishes up on is 3 to the right of the
paste so I can manually enter into that column data. I wanted this done
through a macro, so I recorded one which worked fine except for which cell
it ended up on which was not 3 to the right but ended up on the cell I ended
with when recording the macro.
 
Then Biff gave you a solution. You could have also used OFFSET. I repeat
that you should always post your code for comments and improvement
suggestions.
 
Back
Top