Name conflict
When I save my XLS a dialog box appears indicating the name a1 is in conflict
with a valid range reference or is invalid. How can I remove this error? Thanks, Stefano |
Name conflict
Change the name to something else. Maybe _a1
A1 looks like the address of a cell so you can't use that. smaruzzi wrote: When I save my XLS a dialog box appears indicating the name a1 is in conflict with a valid range reference or is invalid. How can I remove this error? Thanks, Stefano -- Dave Peterson |
Name conflict
Dave,
the point is I'm not using A1 anywhere. Thanks, Stefano "Dave Peterson" wrote: Change the name to something else. Maybe _a1 A1 looks like the address of a cell so you can't use that. smaruzzi wrote: When I save my XLS a dialog box appears indicating the name a1 is in conflict with a valid range reference or is invalid. How can I remove this error? Thanks, Stefano -- Dave Peterson |
Name conflict
You may not think you are, but excel does. And excel wins all ties!
Get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp It'll help you find names--even hidden ones! smaruzzi wrote: Dave, the point is I'm not using A1 anywhere. Thanks, Stefano "Dave Peterson" wrote: Change the name to something else. Maybe _a1 A1 looks like the address of a cell so you can't use that. smaruzzi wrote: When I save my XLS a dialog box appears indicating the name a1 is in conflict with a valid range reference or is invalid. How can I remove this error? Thanks, Stefano -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 07:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com