I am trying to pass a range object from one macro to another and am getting the following errorL run-tim error '42': Object required
Below is the code i am testing. The error occurs on the functiion call to "PassRange(myRange)"
Dim myRange As Range
Set myRange = Worksheets("Mysheet").Range("A1")
Sub PassRange(currentRange As Range)
Thanks for the help.
Regards, Hans Vogelaar
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?