Selecting entire column.

Hello bawahoo,

You can use any of the following:

Selecting a Single Column
Range("A:A").Select 'Selects all of Column "A"
Range("A10").EntireColumn.Select 'Selects all of Column "A"
Cells(1,3).EntireColumn.Select 'Selects all of Column 3 or "C"

Multiple Columns
Range("A5:B10").EntireColumn.Select 'Selects all of Column "A" and all of "B"

Hope this guide helps,
Leith Ross

Thanks for your reply.

How would I add this into the macro...like this???

Sheet2
Range("A1").Select
ActiveCell.FormulaR1C1 = "ACCT NO TOTAL"
Range("B1").Select
ActiveCell.FormulaR1C1 = "=COUNT(Sheet1!D:D)"

Where D contains Acct No in Sheet1. I would to count the num of accts.

???????