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.