It is telling you that in xl2007, it has a column header REV which causes a
conflict with with a file name or some other name in your xl2003 files that
contain rev, so you need to use a subscript line (_) to distinguish that what
you are transferring in is not a range reference. Excel has done it for you,
but you need to save the file to make the change effective.

"Vamsi" wrote:

Hi,

While converting the Macros enabled Microsoft Excel 2003 to Microsoft Excel
2007 format, I am getting the following Conflict with Valid Range Reference
Error. After clicking on the Ok\OK to All buttons the VBA code in the Excel
is not working as it is expected to.

The following is the Error message.

"The name, rev02, either conflicts with a valid range reference or is
invalid for excel. The name has been replaced with _rev02.

You may still need to manually update any references to this name used in
VBA code or as text arguments in functions. You must close and reopen the
workbook before these changes take effect."

and prompting for Ok\OK to All button.

Please pass on any pointers for resolving this issue.

--
Thanks in Advance,
Vamsi