next cell selection

  • Thread starter Thread starter mas
  • Start date Start date
activecell.offset(i,j).select
i is the number of rows, +ve or -ve to move
j is the number of columns
so to select the cell to your left: activecell.offset(0,-1).select
 
Hi Mas

Use the offset command

Activecell.Offset(1, 0).Activate (for 1 to the right)
Activecell.Offset(-1, 0).Activate (for 1 to the left)
Activecell.Offset(0, -1).Activate (for 1 up)
Activecell.Offset(0, 1).Activate (for 1 down)

HTH

Regards

Aussie Bob C.
 
Hi Mas

Use the offset command

Activecell.Offset(1, 0).Activate (for 1 to the right)
Activecell.Offset(-1, 0).Activate (for 1 to the left)
Activecell.Offset(0, -1).Activate (for 1 up)
Activecell.Offset(0, 1).Activate (for 1 down)

HTH

Regards

Aussie Bob C.
 
Sorry mas

Typo mistake

Activecell.Offset(0, 1).Activate (for 1 to the right)
Activecell.Offset(0, -1).Activate (for 1 to the left)
Activecell.Offset(-1, 0).Activate (for 1 up)
Activecell.Offset(1, 0).Activate (for 1 down)

HTH

Regards

Aussie Bob C.
 
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

VBA set thick borders around non empty cells in range 0
Concat a three column range into one cell Then Next... 2
Code to add comments to selected cells within a selected range 30
Clear a "moving" range offset from Target 31
For-Next by a row Counting consecutive Zero in the column 4
Permutations andText to column problem 6
Macro to enter a value, tab to next cell in the row, enter ... 3
Count no empty cells at the right of a selection 2

Back
Top