How do you select an entire column using VBA?

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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

activecell.entirecolumn.select

--
Don Guillett
SalesAid Software

"Phill" wrote in message
...
How do you select an entire column using VBA?

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


"MattShoreson" wrote in message
...

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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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