I have a named range on my sheet. I'm trying to loop through the range's 14th column:
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) code next
I get an error. This is strange because if I do:for each i in range("myrange").columns(14) debug.print i next
It selects the correct range.range("myrange").columns(14).select
Any suggestions?
Bookmarks