Worksheet Set - question on Set?

[itr674]

When I use this code:

Set MenuSheet = ThisWorkbook.Sheet2

I get - "Compile Error: Method or Data Member Not Found."

I have declared MenuSheet with - Dim MenuSheet As Worksheet

When I use:

Set MenuSheet = ThisWorkbook.Sheets(2)

Everything works fine???
This message was edited by em on 2002-10-18 09:36

 

[XL-Dennis]

TsTom,

Plain English.

Thanks for today's english lesson :wink:

Hopefully the use of the name "class" does not complicated even more for the OP!

Kind regards,
Dennis
a regular swedish guy

 

[itr674]

TsTom--thanks I will try your code later today or the other ...

My problem is that I do a lot of copying of code--but I understand what it's doing only about 50% of the time!!

Maybe one day I wll understand more--Thanks for all the help ...

I will have a more interesting question coming up later today ...
This message was edited by em on 2002-10-13 12:44