Cannot Clear Out Used Range

The excel document attached to this thread has a macro designed to create a text string by taking data from the input tab, generating the text string on the TDIN Formula tab, and then copying the result on the TDIN Formula tab on the TDIN tab for each fund. The resulting text string on the TDIN tab is then used to import input data into tax software.

The macro in question is linked to the box at the top of the input tab ("Step 3: Create CCH Import File"). Before you run it, look at the tab titled TDIN, and notice that from row 288 to row 8867, all of the cells are blank, and after this break the text string picks back up and goes to row 11727. If you run the macro, it was designed to delete out all values in the TDIN tab and then paste the updated text string, but it keeps adding a big gap between the first fund and the rest of the funds, and the gap grows every time you run the macro. Every time, it will post the first fund in the place it is supposed to, but then it adds the second fund on after the original usedrange. I have the line "ActiveSheet.UsedRange" in the vba code, which up til 2 weeks ago, worked to clear the used range. Any idea how I can correct this?

Please Login or Register  to view this content.

ActiveSheet.UsedRange does not clear anything, but ActiveSheet.UsedRange.clearcontents can do it