Update Cells Containing Formulas using VBA

  • Hi, I have very little idea of how to program in VBA but I've managed so far by consulting internet forums to obtain the following code to do what I need, but I am getting an error and I don't know what is wrong? Here is the code:

  • Re: Run-time error '91': Object variable or With block variable not set


    what line gets the error? sample workbooks are always beneficial.

  • Re: Run-time error '91': Object variable or With block variable not set


    Hi there,

    Welcome to the OzGrid forum!!

    See how this goes:



    HTH

    Robert

  • Re: Run-time error '91': Object variable or With block variable not set


    Hey guys, thanks for all the support and responses! I've managed to get it working now, thank you!

  • Re: Run-time error '91': Object variable or With block variable not set


    Please post your complete solution showing where the error was and what does done to get it working as you need so that others finding this thread will have a potential solution to a similar need. Thanks.

  • Re: Run-time error '91': Object variable or With block variable not set


    I've eliminated the variables and for each of the formulas with "" inside, I added another set of "" so it became """".

    Like so,

Participate now!

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