Alex has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Selecting a single column in the current region
I can select a whole current region by using activecell.currentregion.select.
But how can I select only one of the columns or rows of the current region?
RE: Selecting a single column in the current region
Hi Alex
Sorry for the delay in getting back to you but our offices have been closed over Christmas. We our now processing all of our forum posts, so we will get back to shortly with an answer for you question.
Thanks
David
RE: Selecting a single column in the current region
try inserting Range("A:A").Select into your code