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.

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.

Hi Dave,

In VBA help see:

'Understanding Scope and Visibility'

and

'Public Statement'

See also the examples provided there.

---
Regards,
Norman



"DaveO" wrote in message
...
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.