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.