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
Re: linking data from a different sheet
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: