Can anyone please tell me why the R1C1 formula line is giving me syntax error? I am using excel 2003. I have a dynamic range of data on report tab and trying to copy from ABC pivot table (on ABC pivot tab) to the report tab starting at the end of the dynamic range of data. I am trying to auto fill the blank cells from pivot table on the report tab using the "if" formula. Hope this is clear..
Thanks a lot!!!
Dim RowCount As Long, myCountRange As Range
Set myCountRange = Columns("C:C")
RowCount = Application.WorksheetFunction.CountA(myCountRange)
ActiveCell.FormulaR1C1 = "=IF('ABC Pivot'!R["&-RowCount&"]C="",Report!R[-1]C,'ABC Pivot'!R["&-RowCount&"]C)"
Thanks a lot!!!
Dim RowCount As Long, myCountRange As Range
Set myCountRange = Columns("C:C")
RowCount = Application.WorksheetFunction.CountA(myCountRange)
ActiveCell.FormulaR1C1 = "=IF('ABC Pivot'!R["&-RowCount&"]C="",Report!R[-1]C,'ABC Pivot'!R["&-RowCount&"]C)"
