vba courses london - Selecting a single column in the current region | VBA forum

Resolved · Low Priority · Version Standard

Tue 19 Dec 2006, 15:59 Delegate 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:46 Trainer 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:51 Trainer Garry said...

RE: Selecting a single column in the current region

try inserting Range("A:A").Select into your code

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

VBA tip:

Stop Screen Flickering When Running Code

Running 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.

To switch off the screen until the program is run enter the following code line:

Application.ScreenUpdating = False

The screen comes on automatically on completion of the program.

View all VBA hints and tips