VBA - Selecting multiple cells using ActiveCell.Offset?

[jst3712]

Hi.
ActiveCell.Offset(0,2).Select would be used to move the active cell 2 cells to the right. Instead of moving it 2 cells to the right, how do I make it so that it highlights/selects the original active cell as well as the 2 cells to the right (so I will then have 3 cells selected). How do I do this?
Normally I would use Range("A1:A3").Select as an example, but what if the cell range reference is unknown and can only go by the "active cell" reference?

Been searching for an answer for about 30 minutes to no avail, so giving this a go It's probably really easy too, but for the life of me I cannot get this to happen.

Thanks in advance.

 

[Norie]

Instead of using Offset use Resize.

ActiveCell.Resize(,3).Select

PS If you need to you can combine them.

 

[jst3712]

Instead of using Offset use Resize.

ActiveCell.Resize(,3).Select

PS If you need to you can combine them.

Beautiful. Thanks!!!

 

[dark_horizon]

Is there anyway to select an adjacent range that is displayed on screen, ignoring the hidden rows and columns?

 

[dark_horizon]

Is there anyway to select an adjacent range that is displayed on screen, ignoring the hidden rows and columns?

Not exactly hidden, its just filtered data.

 

[dark_horizon]

Any solution friends?

 

[gdl25]

Any solution friends?

Would the Select Visible Cells button be helpful for this? I usually customize the buttons in toolbar/ribbons. Try adding this button and simply record a macro using this function and then edit your code again to insert the select visible cells function from the recording. Hope this helps.