Conflict with valid range reference error

S

smaruzzi

When saving some XLS sheets, I get an error claiming "The name a1 either
conflicts witha avalid range reference or is invalid for Excel".
I tried to delete all defined names, but the error message still persists.
Is there a way to get rid of it, and - most of all - what is causing it?

Thanks, Stefano
 
D

Dave Peterson

a1 looks like a range address, so it causes errors.

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 may make it easier to find the error.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Name conflict 3
Conflict with Valid Range Reference Error in Microsoft Excel 2007 4
persistent "invalid reference" error message 2
"Reference is not Valid" 0
Application.Goto Reference gets error 1004 4
Chart data - Range Names 1
Excel 2003 with Reference error cause me a headache 0
Error message refers to Name that can't be found 1

Top