~× wrote:
*All Excel ranges have a rows and columns property; these ar
effecively your dimensions.

e.g

?range("c4:f19").rows.count
16
?range("c4:f19").columns.count
4
You have to take care when indexing i.e. allow for option base. *

Yes that is clear. The question though arised from the fact that when
pivot table is to be created with the wizard, Excel magically enoug
automatically selects the range that appears on the sheet when only on
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
want to avoid manually to select, give or calculate the dimensions o
my range.

Thanks,
Georgio

--
Message posted from http://www.ExcelForum.com