Can't increment Alphanumeric string by one

Attached file 160206 Text Autonumber.xlsm opens with Dashboard containing button that opens Order Form spreadsheet.

When the Order Form is called, I want the Macro to find the latest Job Number in the Job Database worksheet (e.g. "Job 5"), increment it by one as the next number in sequence ("Job 6"), enter that in the next row down, and copy it to Cell C3 in the Order Form.

The "click and drag" approach throws a "1004" error on the Selection Autofill line ("Autofill method of Range class failed")

Please Login or Register  to view this content.

Any pointers or suggestions received gratefully as ever.

Ochimus

Try this:

Please Login or Register  to view this content.

Thanks to both for prompt response and solutions.

Ochimus

Originally Posted by Jim885

Rather than using the .Select or . Activate function that would slow the code down, and have your screen jump from sheet to sheet, try this;

Hi, Jim.
Thanks for the advice. I'll keep that in mind.