stephen antoine
Board Regular
- Joined
- Jun 4, 2008
- Messages
- 128
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:
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?
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:
Code:
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?