linking data from a different sheet [RESOLVED]

I am trying to declare a variable to cell E7 but it only seems to declare that variable from the selected sheet.

I don't actually know how to link E7 from a different sheet to declare it as my variable.

Here is what I have so far...

'Variable_1 = Range("E7").FormulaR1C1


Thanx

Quote:

---

Originally Posted by rovcruiser

I am trying to declare a variable to cell E7 but it only seems to declare that variable from the selected sheet.

I don't actually know how to link E7 from a different sheet to declare it as my variable.

Here is what I have so far...

'Variable_1 = Range("E7").FormulaR1C1


Thanx

---

'Variable_1 = Sheets("Sheet 2").Range("E7") :bigyello: