I have a named range on my sheet. I'm trying to loop through the range's 14th column:

for each i in range("myrange").columns(14)
code
next
This gives me a type mismatch error. I checked the type of .Columns and it says it's a range. Last I checked, I can loop through a range, but if I do:

for each i in range("myrange").columns(14)
debug.print i
next
I get an error. This is strange because if I do:

range("myrange").columns(14).select
It selects the correct range.

Any suggestions?