Issue with adding formula to a excel macro

  • Greetings all,


    i am trying to create a basic macro for some of my guys here at work. i am looking to add in a formula in J2 so that i can copy it down J as a whole. however, when i try to add in the formula i am getting a compileing error stating my statement is not ended after the first Good outcome. any assistance would be appreciated.


  • You need a way to tell the VBA that you're not ending the string, so we use double quotation marks to indicate that "yes, I want a quotation mark here". I also went through and optimized things a little bit

    Best Regards,
    Luke M
    =======
    "A little knowledge is a dangerous thing."

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!