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.

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.

I was under the impression that you design first then code, what I was
asking was design comments. I outlined the design and I wanted your
comments. Do you need more info on the design ?




*** Sent via Developersdex http://www.developersdex.com ***

Hi Samir,

I see few design issues apart from the deciding the scope and lifetime of a
single range variable.

---
Regards,
Norman



"samir arishy" wrote in message
...

I was under the impression that you design first then code, what I was
asking was design comments. I outlined the design and I wanted your
comments. Do you need more info on the design ?




*** Sent via Developersdex http://www.developersdex.com ***