Thread: find range size
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_27_] Nigel[_27_] is offline
external usenet poster
 
Posts: 25
Default find range size

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.