VBA code to identify certain cell in range, then perform goalseek changing that cell

  • All,

    I have a problem that I am certain is challenging only because of my primitive knowledge of VBA, but would appreciate anyone's insight. I have tried to write a short macro which identifies a certain cell in a range, and then performs a goal seek by changing the value of the identified cell. The code I have so far is:



    The syntax "EPCMargin = EPCMargins(1, ActiveCase)" seems to work for identifying the value of the cell in the range "EPCMargins" according to the value of "ActiveCase", which identifies column, but I am not sure how to get an address from this to use in the goalseek function. Any ideas?

    Thanks!

  • Re: VBA code to identify certain cell in range, then perform goalseek changing that c


    Hi Sacurus,
    Nice to meet you.


    Regards, junho

Participate now!

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