As You can see in the following VB code I will have a problem with the cell references made by the ForumulaR1C1 resulting in an absolute reference. The problem is that I want to drag the reference down in the cells below, and I want the column to be absolute but not the row.
The formula makes af reference to another sheet and it looks like this ex:
And I guess what I want is, that the reference looks like this instead:
Can I make FormulaR1C1 write this instead or do I have to change it afterwards?
Jon
Code:
ActiveCell.FormulaR1C1 = "='EKSP-REPORT-SHARE'!R" & tempRow & "C" & monthColumn
Selection.AutoFill Destination:=Range(Cells(rangeStart, companyColumn), Cells(rangeEnd, companyColumn)), Type:=xlFillDefault
The formula makes af reference to another sheet and it looks like this ex:
Code:
='EKSP-REPORT-SHARE'!$L$5
Code:
='EKSP-REPORT-SHARE'!$L5
Can I make FormulaR1C1 write this instead or do I have to change it afterwards?
Jon