Just what I needed. Thanks much.

-----Original Message-----
Try

Dim Col As Range
For Each Col In ActiveSheet.UsedRange.Columns
Debug.Print Col.Address
Next Col

or

Dim Col As Range
For Each Col In ActiveSheet.UsedRange.Columns
Debug.Print Col.EntireColumn.Address
Next Col


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"wired" wrote in
message
...
Thanks, but I don't want to loop through each CELL. I
want
to perform an action on each entire column.

What would you suggest?

-----Original Message-----
Try something like

Dim Rng As Range
For Each Rng In Worksheets("Sheet1").UsedRange
Debug.Print Rng.Address
Next Rng


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"wired" wrote in
message
...
Hello.

I need some guidance here. I want to dimension a
variable
and use it in a "For Each" structure to iterate
through
the "used range" in a sheet. I'm using "Option
Explicit".

In this structure the variable has to be an object or
variant. Since there is no "Column" object already
defined, what should I use that would be most
efficient
and need the least overhead? i.e. Should I just "Dim
as
Variant" or something else?

Your example code would be most appreciated. Thanks
in
advance.


.



.