VBA to change table values

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Hello, I am currently writing a table to enter values. A1:C11. The table has entries of a numerical value between 1 and 3. I would like a macro that, if the value n is entered in Cell A11, then all the other cells on that row change to 1 automatically. IE A1 through to A10. This would also operate for each independent row.

    Thanks in advance.

  • Re: VBA to change table values

    Welcome to the forum!

    Change the value of v to suit. Right click the sheet's tab, View Code, and paste.

Participate now!

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