Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am setting a range ojbect to a specific range:
Set Rng1 = ActualUsedRange ActualUsedRange is a public function which returns a range by selected certain cells in a sheet. Now I know that when I am in a blank worksheet the VBA UsedRange property as displayed in the Immediate Window comes up empty" ?Worksheets("Sheet1").UsedRange There are instances where I will not have a range to pass to Rng1 above via my ActualUsedRange function. For example in a blank worskeet. What error handling do need to put in so that the following line of code will not fail. The way I am currently doing it, I get a Runtime Error 424 Object Required. For Each Cell In Rng1 Thanks EM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Passing several parameters to OnAction property. | Excel Discussion (Misc queries) | |||
Get Property value of class instance by passing string property name | Excel Programming | |||
Property Let: assign return value of Double when passing String | Excel Discussion (Misc queries) | |||
Some worksheet returns NULL for CodeName property. Why? | Excel Programming | |||
Passing null to a function | Excel Programming |