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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ben" wrote in message
...
Don Guillett wrote:
As always, post your code for comments. It's almost always NOT necessary
to select a cell.

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.