Anyone know why this would fail in Excel 2007?[vba]Range(Cells(53,6), Cells(53,106)).Interior.Color = 0[/vba] I get "Method range of object worksheet failed".
A much smaller column argument in the second Cells property will avoid the error, as will different syntax, but I'm curious what's going on here to throw an error. Doesn't look like it should.