Skip to content

Instantly share code, notes, and snippets.

@imamuddinwp

imamuddinwp/Excel macro Offset

Created July 14, 2020 08:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save imamuddinwp/b3683020173867bb5c6295b652e1317f to your computer and use it in GitHub Desktop.
Save imamuddinwp/b3683020173867bb5c6295b652e1317f to your computer and use it in GitHub Desktop.
Download ZIP
Excel macro, Excel VBA macro Offset, powered by Imam Uddin; imamcu07.
Raw
Excel macro Offset
Move one cell down
ActiveCell.Offset(1, 0).Select
Move one cell up
ActiveCell.Offset(-1, 0).Select
Move one cell right
ActiveCell.Offset(0, 1).Select
Move one cell left
ActiveCell.Offset(0, -1).Select
To move more than one cell in any direction, simply change the 1 or -1 to however many cells you want to move over.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment