Hi All,

How can I get an actual Used Range (including charts) in Excel?

The problem is, user will NOT define any print area. But he should get a picture of all used range (including charts) in clipboard:

If I do like, 
Sheet1.PageLayout.PrintArea
It give me a blank string.

If I do like, 
Sheet1.UsedRange.Address
, It doesn't consider the charts which are at bottom.

Please suggest a work-around.

Thanks.