activecell offset

  • Thread starter Thread starter rvik
  • Start date Start date
R

rvik

how do i shift the active cell, two cells to the left.

i know that activecell.offset(0,1) will shift it one cell to the
right.

how to do for right??
 
Beware when you are close to column 1 (Column A)
Activecell.offset(0,-2)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Vba workout if a selection is part of a group? 0
Copy and paste 1
Inserting 2 columns when cells don't match 6
Do while 2
Is Range Offset property needed 1
Cell Selection issue 3
select range next to activecell 3
Variable counting of rows 7

Back
Top