venkat1926
Well-known Member
- Joined
- Aug 21, 2005
- Messages
- 4,824
Plese see the following trivial macro
this gives the dest.address of only the activesheet even though I have indicated it should be that of sheet3.
is it possible to get the dest. address of sheet3 without activating sheet3
if so how is the macro to be modified.? Thanks.
venkat
Code:
Public dest As Range
Sub test()
Set dest = Range("a1").End(xlDown)
With Worksheets("sheet3")
MsgBox dest.Address
End With
End Sub
this gives the dest.address of only the activesheet even though I have indicated it should be that of sheet3.
is it possible to get the dest. address of sheet3 without activating sheet3
if so how is the macro to be modified.? Thanks.
venkat