Import Macro

C

cranen

I have a macro that imports data, deletes blank rows and deletes rows that
meet certain conditions, and it concatenates rows based on criteria. I
import this data because the data is updated on a server every 2-3 months.
My calculations on a different sheet are dependent on the imported data where
the ranges are named and used in the calculations. Why is it that when the
macro imports the data and formats it that the name references are destroyed.
For example, in the name manager Name1 refers to =IMPORT!$A$1010:$A$1219.
I would think that the references would stay the same. They have dollar
signs. Any suggestions?
 
P

Patrick Molloy

difficult to tell withou seeing the code that does the importing. I suspect
its probably deleting the entire named range. Easiest solution would be to
add a few lines of code to rename those ranges..
example

worksheets("Import").Range("A1010:A1219").Name = "Name1"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top