range size from Closed Workbook

[drom]

Hi and Thanks in advance!

is it possible to know the used range contained on Sheet("AA") if this sheet is contained in a closed Workbook??


I could open the Workbook, and check the size of the usedRange but Is there any other way?


eg:
maybe... if in the closed workbook, I add (a dinamic range) named "WWW" then using formulas to check this range's size?

Thanks!

 

[hiker95]

drom,

See if this gets you started in the right direction:
Check out Ole Erlandsen's
http://www.erlandsendata.no/english/index.php?t=envbadac