I am using the Union method to "grow" a range. Each growth increment is via
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.Set Target = Union(Target,NewRange)
Does this make any sense?