Hi Arishy,

What work have you done yourself towards this homework project?

If you show your code thus far and indicate the problems you are
encountering, I am sure that you will receive help.


---
Regards,
Norman



"Arishy" wrote in message
oups.com...
I will appreciate your input in designing a Sub to get all these
proprties for a named range:

Address in RC
Address in cells format eg 4,5
Address of First Row, Last Row Also Columns
Number of Blank cells If any
Number of Rows and Columns
Active Cell address
Name of the workSheet that contains the specified Range

The idea here is to use some public variable, call the subroutine with
a given name,then use the Public variables in any module.