MWE
09-29-2005, 11:07 AM
I am using the Union method to "grow" a range. Each growth increment is via
Set Target = Union(Target,NewRange)
NewRange is typically a single cell. After a few iterations, I test the size of Target and get very strange results. The value for Target.Row and Target.Column is as I would expect. But the value for Target.Rows and Target.Columns is not the number of rows or cols in the current range; but, rather, is the "value" for the last cell (range) added.
Does this make any sense?
Set Target = Union(Target,NewRange)
NewRange is typically a single cell. After a few iterations, I test the size of Target and get very strange results. The value for Target.Row and Target.Column is as I would expect. But the value for Target.Rows and Target.Columns is not the number of rows or cols in the current range; but, rather, is the "value" for the last cell (range) added.
Does this make any sense?