MrExcel Publishing
Your One Stop for Excel Tips & Solutions

vba to move right then shift end down

Posted by brian charles on September 29, 1999 1:02 PM

I need the vba code to select the adjacent cell to the
active cell, then to select all cells down. I will need
plot a graph of the selected region which will be 2 cells
by a variable amount of cells long. I have tried to use
send keys:right and shift down without any luck.


Posted by Chris on September 29, 1999 1:21 PM

Try this:

range(activecell, activecell.offset(0,1).end(xldown)).select