98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Selecting a single column in the current region | VBA forum
vba courses london - Selecting a single column in the current region | VBA forum
Resolved · Low Priority · Version Standard
Tue 19 Dec 2006, 15:59Delegate Alex said...
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?
Tue 2 Jan 2007, 12:46Trainer David said...
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
Tue 2 Jan 2007, 16:51Trainer Garry said...
RE: Selecting a single column in the current region
try inserting Range("A:A").Select into your code
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA tip:Stop Screen Flickering When Running CodeRunning VBA code may cause the screen to flicker as the monitor is the slowest part of the program and cannot keep up with the very fast changes taking place. |
