How to select entire column using VBA

T

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


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


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



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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display entire number in cell 3
Set a column to "text" 2
Autofit 1
Macro to select / highlight entire row. 5
How to use Implicit Intersection in a VBA Function 13
Right click in Pivot Table or on Entire Column 1
Border the selection cell 6
Populate Sheet based on ComboBox selection 5

Top