Handle #Name? with VBA

[Burnsieboy]

Hi all,

I am updating around 90 workbooks for year end by adding an extra named range to an existing formula
I will be doing this by looping through all of the workbooks to add the 18/19 spend in year to 15/16 16/17 17/18

    Range("HRPreviousYearsSpend").Select
ActiveCell.Replace What:=")", Replacement:=",Year_18_19_Total_Project_Cost_Total_inc_VAT)", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False

My issue is that not all of the workbooks have the new named range in them which will result in #Name ?

Does anyone know of a way to handle it 'live' or run a fix after the updates are complete

 

[Joe4]

You can use error handling.
See here: https://www.mrexcel.com/forum/excel-questions/55050-how-identify-if-named-range-exists.html

 

[Burnsieboy]

Thanks Joe

That looks workable I'll give that a try

 

[Burnsieboy]

Just the job. Had to break what I wanted to do into 3 subs but it trickled along fine

Thanks again

 

[Joe4]

You are welcome.