worksheets declaration

[diddi]

Greets all
i am having a bit of a mental block and can't seem to get this declaration syntax right. i want to declare a worksheets variable globally
eg

Public Constant data as workbooks = Sheets("MyDataPage")

so that in code i can use

data.cells(1,2) etc

TIA

 

[tweedle]

I'm not sure I've ever seen an object assigned as a constant...

Public data As Worksheet
Sub startup()
Set data = Sheets("MyDataPage")
data.Cells(1, 1) = StrReverse("sdrawkcabemyalp")
End Sub