Thread: How do you add 1 to an invoice number in Excel. Formula for this?
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
bhawane bhawane is offline
external usenet poster
  
Posts: 12
Default How do you add 1 to an invoice number in Excel. Formula for this?

Simple solution ...

Private Sub Workbook_Open()
MyInv = Sheets("Sheet1").Range("A1").Value
MyInv = MyInv +1
Sheets("Sheet1").Range("A1") = MyInv
End Su

--
bhawanePosted from http://www.pcreview.co.uk/ newsgroup acces

Reply With QuoteReply With Quote