Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Having a problem getting to "Range" objects to test as equivalent. In the
simplified code below after calling Sub One and then Sub Two with the same "Range" argument the MsgBox displayed the addresses of X and C as the same, but failed to evaluate the Object X and C as being equivalent. What's wrong with the code? (Of course this assumes my simplified code below accurately represents my actual code :-) Simplified code: Sub One (ByVal A As Range) Call Test(A, True) End Sub Sub Two(ByVal B As Range) Call Test(B, False) End Sub Sub Test(ByVal X as Range, Flag As Boolean) Static C As Range MsgBox X.Address & " " & C.Address ' After Second Call to Test both addresses show the same value. Select Case Flag Case Is = True Set C = X Case Is = False If X Is C Then MsgBox "X is C" Else MsgBox "X is not C" End If End Select End Sub Call One(R) ' Where R is a cell reference (Range). Call Two(R) ' Where R is same cell reference. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2 Label Options - Forms Object vs Control Box Object | Excel Discussion (Misc queries) | |||
Object Variable Not Set Error on Selection object | Excel Worksheet Functions | |||
Option button object proeprties or object not found in vba | Excel Programming | |||
Confusion about how the Window object fits into the Excel object model | Excel Programming | |||
Range object to Array object conversion | Excel Programming |