Auto Generate Invoice Number

  • Code
    Sub newserial()
    Range("b10").Value = Range("b10").Value + 1
    End Sub


    this is a small code to generate new invoice number and i want a restriction value code with it. if the value goes to 10 by pressing this button than it should show msg cannot go more than 10 value.
    can sumbdy write it for me.

  • Try this:



    Regards,


    Robert


  • these codes copy data from 1 sheet to another sheet CAN YOU PLZ WRITE CODES IN THESE THAT CELL SHOULD NOT BE BLANK CODE BEFORE COPY DATA

Participate now!

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