Thread: find range size
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default find range size

=ROWS(DRP)
=COLUMNS(DRP)

Regards,
Stefi

€žNigel€ť ezt Ă*rta:

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.