Count of Rows in Range ..... does not seem correct

I have the following macro (see enclosed).

In the macro i attempt to determine the number of rows via these code steps

MsgBox ("rng rows count is     " & rngSourceData.Rows.Count)
MsgBox ("rng cols count is   " & rngSourceData.Columns.Count)

But for some reason the counts are 6 and 6 and i expected 20 and 6.

Any ideas