I feel like there has to be an easier way to do this than what I have tried so far. I have working code that copies a table's values into a 2D array. The table is 10 columns wide. What I am doing is copying the table into this array and doing some calculations and sorting on it. What I need to do now is spit back out 5 of those 10 columns back into the table. I don't want to output all 10 columns. I just want to overwrite 5 of the columns with new data because the other 5 are formulas that I need to preserve. How can I use specified array columns to overwrite specified table columns? In case it matters, the length of each column (ie the row count) doesn't change when I'm doing calculations within the array). Can I make sure of the databodyrange and listcolumns or something to do an easy copy, or must you do a more complicated loop of some sort? Thanks in advance for any help you can give!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Copy Parts of Array to Certain Table Columns
Similar threads
- Solved
- Question
