Gixxer Lad
New Member
- Joined
- Dec 21, 2004
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
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
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