9tanstaafl9
Well-known Member
- Joined
- Mar 23, 2008
- Messages
- 535
Anybody know what I did rong with this?
Honestly, I'd like to just use a named range, but that didn't work either. If I replace C:CA with A:A it works fine. I tried A:D and that worked fine, but when I try to go into the double letter alphabet columns it breaks (I don't know if that's what I'm doing wrong or if it's conincidental).
Really, all I'm trying to do is make all the columns in a named range the same width (the width of the widest of those columns in that range), using VBA. If someone knows an easy way to do that you can forget my original question...
Thanks!
Jennifer
Code:
Range("c:ca").Find(Application.WorksheetFunction.Max(Range("c:ca"))).Select
Honestly, I'd like to just use a named range, but that didn't work either. If I replace C:CA with A:A it works fine. I tried A:D and that worked fine, but when I try to go into the double letter alphabet columns it breaks (I don't know if that's what I'm doing wrong or if it's conincidental).
Really, all I'm trying to do is make all the columns in a named range the same width (the width of the widest of those columns in that range), using VBA. If someone knows an easy way to do that you can forget my original question...
Thanks!
Jennifer