Selecting cells based on a array

[Gixxer Lad]

Good afternoon all,
Nice easy one for you I expect, I am trying to select all the cells in a particular column based on an active range. I am using “Cells(ActiveCell.Row,2).Select” for column B of a single selection but I require the same to work on a range eg. If I select A2:J10 I would like to select B2:B10.

Hope this makes sense, any assistance is appreciated.
Thanks

 

[Fluff]

Hi & welcome to MrExcel.
If you selection always includes col B how about

Intersect(Selection, Range("B:B")).Select

 

[Gixxer Lad]

Hi & welcome to MrExcel.
If you selection always includes col B how about

Intersect(Selection, Range("B:B")).Select

Thank you very much, I will retain this nugget but unfortunately column B may not be included.
Best regards

 

[Fluff]

In that case how about

Intersect(Selection.EntireRow, Range("B:B")).Select

 

[Gixxer Lad]

In that case how about

Intersect(Selection.EntireRow, Range("B:B")).Select

Wonderful, thank you very much.
Have a nice evening

 

[Fluff]

You're welcome & thanks for the feedback.

 

[smozgur]

Wonderful, thank you very much.

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.