"Bob Phillips" wrote in message
...
Is the range more than one cell? That could be the problem.

Help states that the property applies to a RangeCollection, which is:

"Represents a cell, a row, a column, a selection of cells containing one or
more contiguous blocks of cells, or a 3-D range."

I have tried both Select and Activate on the range, still no height
adjustment,