Pausing formula in name manager

How about disabling recalculations while macro imports data

something like:

sub YourImportSub()

dim currentrecalcmethod as long
currentrecalcmethod = application.calculation
application.calculation=xlcalculationmanual

'... your code

'... end of current code

application.calculation=currentrecalcmethod 
application.calculate
end sub

No, it's the same, but how could I know that you already have it ?
Of course you could try to delete the names in name manager (or change them from "formula based" to "range based") form before starting the main part of the code and restore after the import is done.

So you can display in immediate window (but the same will be to store in a string variable) a name in such a way:

debug.Print ActiveWorkbook.Worksheets("Sheet1").Names("Yournamedvariable").RefersTo

you shall see the formula it refers to
then you can set a new reference like:

ActiveWorkbook.Worksheets("Sheet1").Names("Yournamedvariable").RefersTo ="=Sheet2!$C$12:$C$15"

and after importing use the same way to restore it

If your names have a workbook-wide scope then ommit Worksheets() part.

No, no offence. I know it's not easy to give just enough details (too few - there will be too obvious answers, too many -> TLDR)
A yellow box at the top of this page gives quite useful (often) hint

Glad to hear it worked for you.

Thanks for marking thread solved and for appreciation