One way:

?Range("C4").CurrentRegion.Rows.Count

?Range("C4").CurrentRegion.Columns.Count

In article ,
banavas wrote:

Yes that is clear. The question though arised from the fact that when a
pivot table is to be created with the wizard, Excel magically enough
automatically selects the range that appears on the sheet when only one
cell of the range is selected.
That means that it can found the U & L bounds of the range.

In my application the input range may vary in terms of dimensions and I
want to avoid manually to select, give or calculate the dimensions of
my range.