Bob asks “I need to import data in a flat file on a daily basis, each file is an addition to the previous one. I have recorded a
macro that works fine for the first import, but as the destination is a named cell it only works once. How can I change
the macro so it writes the data to the active cell rather than a named one?.”

Change your recorded macro where it says something like

Range(“MyRange”)

To

ActiveCell