Increment Alphanumeric Value of a Cell on each print job

hello I need help with the following macro, it works great but only with numeric values but it doesn't work with alphanumeric values.

Please Login or Register  to view this content.

for example I want the following value G20141530 in F7 to increment by one after each print so if I print 5 sheets I get G20141530,G20141531,
G20141532 and so on. any help would be greatly appreciated.

thanks xladept for your help, code works great the only thing is when I cancel the printjob I get a debug error. I have underline the debug error in the code.

Please Login or Register  to view this content.