How to select entire column using VBA
 

How do you select an entire column using VBA?

How to select 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

How to select entire column using VBA
 

activecell.entirecolumn.select

--
Don Guillett
SalesAid Software

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

How to select 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