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.