correct syntax?

What is the correct syntax?


This is in Excel VB.

Dim mysheet As "activeworksheet"
ca1358Asked:
Who is Participating?
 
GrahamSkanConnect With a Mentor RetiredCommented:
Dim mysheet As Worksheet
set MySheet = ActiveWorksheet
0
 
GrahamSkanRetiredCommented:
Typo. Should be

set MySheet = ActiveSheet
0
 
ca1358Author Commented:
Thank you!
0
 
GrahamSkanRetiredCommented:
That must be the quickest acceptance ever. I realised my error as soon as I hit Submit, but I'm a slow typist.
0
 
GrahamSkanRetiredCommented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.