Im combining several sheet into one. During the selection process I end up starting at A1 and selecting all used cells however, I end up selecting some blank rows below the populated rows. It happens whether Im using
ActiveSheet.UsedRange.Rows.Select
or
Selection.CurrentRegion.Select

Im guess it picking up some old formating or blanks or???
Question is, how can I chose only the realy populated rows.
The rows are contiuously populated, no blanks in the field of data
thanks
Robert