Using .Formula with variable in cells object

Question

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?

Sam Gilbert · Accepted Answer · 2016-03-23 19:26:08Z

3

Try the below, I believe you were nearly there, but you inserting an unnecessary space before the equals sign + the quotes were out.

main.Cells(main_row, calc_col).Formula = "= J" & main_row & " / I" & main_row

edited Mar 23, 2016 at 19:26

answered Mar 23, 2016 at 19:22

Sam Gilbert

1,7023 gold badges24 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using .Formula with variable in cells object

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related