ActiveCell instead Named Range
May 20, 2002 - by Juan Pablo Gonzalez
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