Each entire column? Or that portion of each column that is within the range?

Alan Beban

wired wrote:
Thanks, but, I don't want to loop through each cell...
I want to perform an action on each entire column.

What do I do in that case?


-----Original Message-----
Dim cell as Range
for each cell in Activesheet.UsedRange
' debug.print cell.address
Next

--
Regards,
Tom Ogilvy

"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.


.