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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.