Re: VBA Excel =?windows-1252?Q?=93Set=94 question?=

In the 2nd workbook create a reference to the 1st workbook (Tools |
References...). Whether you need a Set or not depends on the type of
variable.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <UR2Cf.11772$zh2.321@trnddc01>, john.thomas211@xxxxxxxxxxx
says...
> I am trying to use a variable that was declared as =3FPublic=3F at a Module
> level in one workbook, in a second workbook. I know I need to use a
> =3FSet=3F statement, but so far I have not come up with the correct
> combination to make it work. I am relatively new to VBA and would
> appreciate any suggestions.
>
> J. Thomas
>
>
.

Relevant Pages