Make a search with "Workbook level variables" in Programming topic! Just
below your post you will see my old question with excellent answers from Tom
Ogilvy and Bob Phillips!

Regards,
Stefi


€žDaveO€� ezt Ã*rta:

Guys, I need to create a workbook, not worksheet level VBA variable.
Basically something that spans the whole of the workbook and that can be
accessed by each and every worksheet.

Any ideas on where I can specify this and how?

TIA.