I've used some VBA code to place a formula into a cell but I'd like to perform the calculation in VBA instead if it's possible. The trouble I'm having is that the values and the result are all on different pages and I'm unfamiliar with how to reference each data point for the Round function
I started with putting a formula in the cell using:
- Sheet3.Range("H8") = "Round('Unit Data'!E3*'Rate Data'!A39,0)"
For example
- On Sheet1 I have a value in cell E3, 11
- On Sheet2 I have a multiplier in cell A39, 60%
- On Sheet3 I have a field for the result H8
My hope is that the result of "7" ends up in Sheet3 cell H8.
Bookmarks