Get Formula in Cell rather than Value

[stephen antoine]

Good evening,

I have a bit of code that uses variables to select a specific cell and then performs a calculation and dumps the value in the active cell...The problem is that I want the formula to be in the cell not the value...

The code I used is as follows:

ActiveCell.Formula = Cells(FinalRow + 2, CYSales).Value / ActiveCell.Offset(-5,0)

Where FinalRow and CYSales are my row and column variable...

My code works, but it dumps the value in the cell, I want the formula..

Can someone please help?

 

[zzjasonzz]

ActiveCell.Formula = "=" & Cells(FinalRow + 2, CYSales).Value & "/" & ActiveCell.Offset(-5, 0)

 

[stephen antoine]

Thanks, that seemed to work partially, because now instead of a single value it's the value of the first cell divided by the value of the second cell, like the following:

=50/10

Where 50 is in cell C35 for instance and 10 is in cell E40

But I'm trying to get the cell reference to show up as well so the result would be something like this:

=C35/E40

Is that possible?

 

[Scott Huish]

ActiveCell.Formula = "=" & Cells(FinalRow + 2, CYSales).Address(0,0) & "/" & ActiveCell.Offset(-5, 0).Address(0,0)

 

[stephen antoine]

GREAT!!! That worked....thanks so much