asked on

VBA Named range error

I have been working with the named ranges in my project with no issues, but suddenly I have an error that I can't resolve.
I am hoping that someone can help me identify where the issue is.

The error snippy is attached as well as the project.
The named ranges code is on Net Rate sheets 1 & 2 - they are the same, but for different sheets.

I have only recently added "Ground Deferred" "GR_DEF" & "Ground CA" "GR_CA"
I tried different naming conventions - removing the underscore and such, but still get the error.

The other named range is on hidden sheet NAMED RANGES. It is the only one seeming to be still working correctly.

The project is run by clicking Re-rate button on Enter Data sheet.
ALMOST completed this project and now stuck!!
Can anyone help please????

Rerate-v5.3-sample.xlsm

ASKER CERTIFIED SOLUTION

Rory Archibald

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Roy Cox

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Martin Liss

With that one exception, all your named ranges have #Ref! errors. Got to Formulas->Name Manager and you'll see them. I assume it happened when you copied a sheet. In any case I believe you'll have to manually reset their ranges.

Euro5

ASKER

Don't know why I was getting that error - but you were right, I fixed the IF statements and it ran smooth.
Thanks so much for pitching in there. Very happy.

Roy Cox

Glad we helped. You need to learn about debugging your code, this should help

Drbug VBA Code