I have an Excel spreadsheet that is used to import and calculate values based on the imported data. I use VBA to perform the importing and copying of cells etc. All of the importing and computations are performed on the same sheet/table. The data is imported properly into columns a-j, usually around 120 rows. When I copy the formulae down in columns k-v, all of the rows except for the first data row, happens to be row 2, work. The formulae are using table syntax [@[]]. If I replace a value in the data section the formulae update and all is good. This only happens on first import. To be clear, the range IS a table. Any suggestions?
0 Answers
Related