How can I do something like this:

Dim Sheet2 As String
Sheet2 = "EURUSD historical data"

Dim HighAsk1 As Worksheet
Set HighAsk1 = Sheets(Sheet2)

x = 9
HighAsk(x) = HighAsk1.Cells(x, 3) < this doesnt compile due to type mismatch
Any thoughts?

I basically want to call a variable "HighAsk(x)" inside for loops that references: Sheet2.Cells(x,y) so it makes for reading my code a lot easier!