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