How to select entire column using VBA

[Phill]

How do you select an entire column using VBA?

 

[MattShoreson]

worksheets("sheet1").rows("A:A").select

 

[Don Guillett]

activecell.entirecolumn.select

 

[Tom Ogilvy]

What you posted raises and error. Perhaps you meant:

Worksheets("sheet1").Activate
Worksheets("sheet1").Range("A:A").select

or
Worksheets("Sheet1").Activate
Worksheets("Sheet1").Columns(1).Select

--
Regards,
Tom Ogilvy

worksheets("sheet1").rows("A:A").select


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements