Trouble finding column address after column "Z"

Hello all,

I have not been able to find a solution on how to pull a column's address after letter "Z" without having to write a function. In my code, I have a loop copying columns by offsetting a reference.

Please Login or Register  to view this content.

The problem is when I reach column "Z", this code is not able to give me "AA". Is there a way of changing this line to be able to read any column, including "Z" and "AA"?

Thanks.

Wow! This was really helpful. Thank you so much!!!!