Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import Macro
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Macro in PERSONAL.XLS will not import to my main document | Excel Programming | |||
Import macro | Excel Programming | |||
Import From with macro | Excel Programming | |||
Import macro from another workbook by macro | Excel Programming | |||
Import and run Macro | Excel Programming |