PDA

View Full Version : Get entire worksheet range



chrisjones
08-03-2010, 02:08 AM
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
08-03-2010, 02:21 AM
Set rng = Activesheet.Usedrange

chrisjones
08-03-2010, 02:47 AM
Great, that solved the problem.

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

Chris

Bob Phillips
08-03-2010, 03:19 AM
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.