Incremental Numerial Increase in a Merged Cell
Posted on 2010-01-04
I am using the following macro in excel to auto increase a work order number by 1 when the workbook is opened; however, I want to move where the work order number is located in the spreadsheet from cell A1 to a merged cell located at AO4:AR4. When I change the second line of the macro from ("A1") to (AO4") the macro does not work but instead returns the following error "Run-time Error '13':
I tried putting replacing A1 with the range A04:AR4, but I get the same error. I would like to keep this fix very simple if possible by just changing the second line. Any help would be appreciated.
Selection.Value = Selection.Value + 1