"Nigel" skrev i en meddelelse
ups.com...
so i have a range named Range("DRP")
that range is always changing, and i would like to know how many cells
wide and long it is..
for example....if currenty Range DRP is from A1:D5, i want to know that
it spans 5 columns and 4 rows.


Nigel

Number of columns:
Range("DRP").Columns.Count

Nuber of rows:
Range("DRP").Rows.Count

--
Best regards
Leo Heuser

Followup to newsgroup only please.