ca1358
asked on
correct syntax?
What is the correct syntax?
This is in Excel VB.
Dim mysheet As "activeworksheet"
This is in Excel VB.
Dim mysheet As "activeworksheet"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you!
That must be the quickest acceptance ever. I realised my error as soon as I hit Submit, but I'm a slow typist.
Thanks
set MySheet = ActiveSheet