Genrating next invoice number with a letter in front of it

I am having difficulty getting the next invoice number to change with the invoice e.g i create invoice no 'G101' and would like the next invoice to be 'G102' I have no problem generating the next invoice number when only using number e.g '101' to '102' however when i add a letter in front it becomes a nuisance.

I currently use - Sub NextInvoice()
Range("H11").Value = Range("H11").Value + 1


H11 being the cell that the invoice number is in.

Can anyone help or suggest a way to get it working? I'm not too experienced on excel so i apologize in advance for the rubbish explanation.

I wouldnt bother with VBA, just use a formula.
If your first invoice is in H10 (G101 for example)

then place this in H11


=LEFT(H10,1)&(RIGHT(H10,3)+1)

and drag that down.

Double click any cell in column "H" with your basic number and the next number will appear below.

Please Login or Register  to view this content.

Thanks Guys!

I used zbor answer.