Ohh..
ok. Now I understand. here you go.
This is the code you should use:
Code:
Sub movecell()
i = 10
ActiveCell.Offset(rowOffset:=0, columnOffset:="" & i).Activate
End Sub
Here are the instructions where to type the code:
1. Open the VBE with Alt-F11.
2. Open the Project Explorer with control-R (it might already be open, that's OK.)
3. Select the file you're working on in that window by clicking it.
4. Select Insert, Module from the drop down menus.
5. Open the Code window by pressing F7. This, too, might be open already.
6. Copy Paste/Write the code.
8. Run the code by pressing F5 from the VBE or from Excel under the Tools, Macro, Macros menu.
Hope this helps.