I'm going nuts trying to figure out what's wrong with this bit of code:
Range(r1.Offset(, bias2), r1.Offset(0, bias1 +
bias2)).EntireColumn.AutoFit
When executed no autofitting occurs. No error either. If I look at the
individual ranges they have addresses like $G$11 and $R$11 respectively.
If I change the code to:
Range(r1.Offset(, bias2).Address, r1.Offset(0, bias1 +
bias2).Address).EntireColumn.AutoFit
then it works as expected but I don't typically turn my ranges into
addresses and they've always worked OK. So why not here?
I also tried:
r1.Parent.Range(r1.Offset(, bias2), r1.Offset(0, bias1 +
bias2)).EntireColumn.AutoFit
but that didn't change anything (i.e., it still failed to autofit).
Anybody got any idea what's going on?
TIA,
josh
p.s. I'm doing this testing under XL97
Bookmarks