Import Macro

  • Thread starter Thread starter cranen
  • Start date Start date
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?
 
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"
 
Back
Top