Help with formula in cell using VBA

  • Hi all, here is the line of code I'm trying to input a formula in a cell:

    Code
    1. range("G"&i).Formula="=(F"&i+1)


    The column for the find routine will always be column A, and the amount wanted will always be in column F, and the formula will always be in column G.


    Thank you,


    Neil

  • Try: Range("G" & i).Formula = "=(F" & i & "+1)"

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

  • You are very welcome. :)

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.