VBA code convert letter into specific numeric no.

  • Hi,

    I am trying to work out a code in a worksheet to change letter "Y" into "1" and letter "N" into"0" when typed in any cell on the sheet excluding column A & B and Rows 1 - 5.

    Any help would be appreciated.

    Apologies if this is duplicate request but couldn't find any similar post.

  • This goes into the worksheet module.

Participate now!

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