GlazedIZ
02-10-2005, 07:29 PM
This is gonna show my ignorance, but I'm banging my head...
I'm populating a worksheet ("Scorecard")with data from another worksheet, but I'd like it to create a Reference to the data instead of the value.
I thought I was on the right track with the lines below,
wSheetstr = "='" & wSheet.Name & "'!"
Worksheets("Scorecard").Cells(ScorecardRow, 1).Formula = wSheetstr & "A8"
This works, but the problem is that (in another line), I'd like to use variables (R1C1 format) to locate where the Referenced cell is located.
In other words, the following line populates the scorecard with the correct data...
Worksheets("Scorecard").Cells(ScorecardRow, 3) = _
wSheet.Cells(Ycounter + 2, Xcounter + 5)
.... But Id like it to populate it with a Reference to the data instead.
(& preferably have the Reference in A1 format, but as long as works I dont care)
Any ideas? - I'll bet it's so simple.
I'm populating a worksheet ("Scorecard")with data from another worksheet, but I'd like it to create a Reference to the data instead of the value.
I thought I was on the right track with the lines below,
wSheetstr = "='" & wSheet.Name & "'!"
Worksheets("Scorecard").Cells(ScorecardRow, 1).Formula = wSheetstr & "A8"
This works, but the problem is that (in another line), I'd like to use variables (R1C1 format) to locate where the Referenced cell is located.
In other words, the following line populates the scorecard with the correct data...
Worksheets("Scorecard").Cells(ScorecardRow, 3) = _
wSheet.Cells(Ycounter + 2, Xcounter + 5)
.... But Id like it to populate it with a Reference to the data instead.
(& preferably have the Reference in A1 format, but as long as works I dont care)
Any ideas? - I'll bet it's so simple.