G
Guest
Using XL 2003 & 97
The following code works but it enters on sheet1 the value when I really
want the link to the cell on sheet2
Sheets("Sheet1").Cells(Rows.Count, 10).End(xlUp)(3, 1).FormulaR1C1 = _
Sheets("Sheet2").Cells(Rows.Count, 10).End(xlUp)(1, 1)
I thought the .FormulaR1C1 would have done that.
In short, the code reaches to Sheet2 properly finds and gets $99,999.99
But I want something like ='Sheet2!'A20 then on sheet1 displays $99,999.99
via formula.
TIA Dennis
Sheets("Sheet1").Cells(Rows.Count, 10).End(xlUp)(3, 1).FormulaR1C1 = _
Sheets("Sheet2").Cells(Rows.Count, 10).End(xlUp)(1, 1)
The following code works but it enters on sheet1 the value when I really
want the link to the cell on sheet2
Sheets("Sheet1").Cells(Rows.Count, 10).End(xlUp)(3, 1).FormulaR1C1 = _
Sheets("Sheet2").Cells(Rows.Count, 10).End(xlUp)(1, 1)
I thought the .FormulaR1C1 would have done that.
In short, the code reaches to Sheet2 properly finds and gets $99,999.99
But I want something like ='Sheet2!'A20 then on sheet1 displays $99,999.99
via formula.
TIA Dennis
Sheets("Sheet1").Cells(Rows.Count, 10).End(xlUp)(3, 1).FormulaR1C1 = _
Sheets("Sheet2").Cells(Rows.Count, 10).End(xlUp)(1, 1)