Hi,
I'm wondering if someone can help me with the VBA code to select a range of cells within the column of the active cell. I'm wanting to select the cells in row 3 to 167 but only within the column of the active cell.
I hope that makes sense.
Hi,
I'm wondering if someone can help me with the VBA code to select a range of cells within the column of the active cell. I'm wanting to select the cells in row 3 to 167 but only within the column of the active cell.
I hope that makes sense.
Something like
Please Login or Register to view this content.
One more way (although I think I like jindon's first code line best)...
Formula:Please Login or Register to view this content.
Last edited by Rick Rothstein; 12-31-2021 at 03:05 AM.
Thank you. All options worked. I went with jindon's first option as it is the one i understand the most. The only thing I'm unsure of is the meaning behind the use of 'a' in the range?
There are more ways like
When you refer a range/cell/column/row Range/cells/column/row plays as reference.Please Login or Register to view this content.
e.g
HTHPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks