Recording a macro in excel that does this?

Question

I want to record a macro that will go to the toolbar and select: edit/paste special/unicode text

I know how to do this, but the problem is that it keeps pasting in the same cell no matter where i actually put the cursor. do i have to record it a certain way to get it to paste in whatever cell i want? thanks.

Answer 1

Key State is ActiveCell.Offset -  This line of code was written with the active cell  J10.  When run, it moves active cell to K12 -  2 rows down 1 column right.

  ActiveCell.Offset(2, 1).Range("A1").Select

Just modify the offset to reflect what change in cursor position you want.  BTW - this is real easy to write in Excel 2007