Raani has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Named range error
I keep getting an error message saying 'a formula in this worksheet contains one or more invalid references. Verify that your formulas contain a valid path, work book, range name and cell reference.'
I search the workbook for '#REF!' and have cleared all of these. Some tabs were deleted which is why I think this may be a range name issue but im not sure how to find the error?
Thanks
RE: named range error
Hi Raani
Thanks for getting in touch. In can be difficult tracking down that rogue formula. Let the Go To window help you out.
Whilst in your workbook press CTRL G. This will bring up the Go To dialogue. Click on the Special button and choose Formulas. If you uncheck everything except Errors, clicking OK will show you where the errors are in your workbook.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: named range error
Hi Gary,
I tried this and it says 'No cells were found' but when I try saving it the same message comes up.
Thanks
Raani
RE: named range error
I've just seen it's Excel 2007 and that this may be the reason:
http://support.microsoft.com/kb/931389
Thanks for your help
Raani
