I have a long formula in an Excel sheet and when I record a macro that adds the formula to a cell, it jumps to the next line after a certain number of characters and adds " &_ at the end of the line but 4 or 5 of the characters that were there in excel are now not there in VBA code after the macro has recorded. I added the missing characters and the formula compiles correctly in VBA but when I try to run it on the data in the spreadsheet, I get a runtime error on the formula.
This is similar to another problem that was reported on this post:
http://www.excelforum.com/excel-gene...ml#post4226175
Can anyone please provide feedback on why these characters disappear and on why the code compiles correctly in VBA but I get the runtime error when trying to run?
Here is code:
The active cell formula in red text is the line with the problem.
Thanks.
Bookmarks