I've been working on a macro that concatenates a very large spreadsheet, and I finally figured out how (thanks to the kind users on here!). However, the next step is to delete the fields that are concatenated into one, and when I run this macro, I get a bunch of #REF where my concatenated strings used to be! So now, my question is, how do I have the cell equal the result of the formula and not the formula itself?
For instance, you type =(SUM A1:A3) in cell C1. The sum of cells A1 through A3 appears in cell C1. However, when you delete the values in cells A1-A3, the value changes in C1. So how can you just keep the result of the formula, without the formula itself?
The answer is probably easy, but I've been spending the last four hours this morning hashing out macros in VB, when I had never touched one before and my brain is fried!!!