Get Actual Print Area of an Excel Sheet (Through VBA)

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.