Get entire worksheet range

[chrisjones]

I would like to programmatically get the range for the enitre active worksheet. Manually I can see it is ("A1:IR65523") but how do I get it programmatically

Thanks

Chris

[Bob Phillips]

[vba]

Set rng = Activesheet.Usedrange
[/vba]

[chrisjones]

Great, that solved the problem.

How come when i type "ActiveSheet." intisence does not show anything in my vba editor?

Chris

[Bob Phillips]

Activesheet is an instance of Sheet, which can be a Worksheet, it can be a Chart, etc. Only worksheets have UsedsRange, so it won't show as a property of Sheet.