MrExcel Consulting
Your One Stop for Excel Tips & Solutions

ActiveCell instead Named Range


May 20, 2002 - by Juan Pablo Gonzalez

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