Range Selection Using Offset.

[mcmccompguru]

I want to select a range using the offset method. I have a cell activated, and I need to select two ranges from that cell. This all needs to be relative because the active cell will likely never be the same cell twice. Say the active cell is A1. Well, I need a section of code using the offset method to set A1:A10 as Range1, and then, using the same active cell, I need another range as A13:16, Range2. Again, I need to use Offset, or something to keep the references relative to the active cell and assign two ranges from there. Thanks in advance for the help.

 

[Stretchwickster]

Assuming that the activecell remains the same throughout then use this code for the 1st range:

  Range(ActiveCell, ActiveCell.Offset(10, 0)).Select

and this code for the 2nd range:

  Range(ActiveCell.Offset(13, 0), ActiveCell.Offset(16, 0)).Select

Hope this helps!

Clive

http://www.kucu.co.uk

Ex nihilo, nihil fit (Out of nothing, nothing comes)

 

[Zathras]

.Offset is zero-based, so the code you need is
[blue]

  Range(ActiveCell, ActiveCell.Offset(9, 0)).Select

[/color]
and
[blue]

  Range(ActiveCell.Offset(12, 0), ActiveCell.Offset(15, 0)).Select

[/color]
Alternatively, some people have difficulty with-based references so you may be more comfortable with using .Cells instead of .Offset like this:
[blue]

  With ActiveCell
    Range(.Cells(1, 1), .Cells(10, 1)).Select
  End With

[/color]
and
[blue]

  With ActiveCell
    Range(.Cells(13, 1), .Cells(16, 1)).Select
  End With

[/color]

 

[mcmccompguru]

Thanks for the help. I had already caught the zero base error, thanks though. The alternative method was helpful to know, also. Thanks for the help!!!