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.
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,