I've tried a variety of concats and uses of "" but I cant get .formula to work in the following code. The macro runs without error but it does not populate my sheet. I feel like this: Excel VBA formula with variables is what I am going for but main_row does not appear to be getting assigned to the variable when it is inside the .formula.
main_row = main.Range("b6").Row
calc_col = main.Range("k6").Column
main.Cells(main_row, calc_col).Formula = " = j & main_row / i & main_row "
- Is it possible to use .formula with cells object?
- Would rather not use application.worksheetfunction because i want end user to see the formula
- Anyone have a good source to explain the proper way to qualify variables within .formula?