VBA to change table values

  • 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!