Defining a range

  • Thread starter Thread starter JDBAZ
  • Start date Start date
J

JDBAZ

How do I select a range defined as the currently-selected cell to a cell a
specified number of cells away, both vertically and horizontally?
 
I'm not sure how you will want to specify the new cell's coordinates, so
I'll leave the method and math to you; however, you would use something like
this...

ActiveCell.Resize(5, 3).Select

When executed, the Selection will start with the ActiveCell and be 5 rows
deep by 3 columns across.

Rick
 

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
random range of cells via cell names 3
Excel VBA 1
Question about how to use range in VBA 2
Macro to Define Name on a changing selection of cells 5
Process all cells in a (user) selection - vba 2
VBA get range from cell offset 3
define range using col and row names; not cell name 3

Back
Top