Counter
In the thisworkbook module in the workbook_open macro use
sheets("sheet2").range("a1").value=sheets("sheet2" ).range("a1")+1 Don Guillett SalesAid Software Granite Shoals, TX "Andrew" wrote in message ... Everytime my workbook opens, I want a new number assigned to a worksheet, simply 1 plus the last number. I keep getting a circular reference. Any ideas? Thank you! |
All times are GMT +1. The time now is 10:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com