I received the attached Rick Rothstean "Original" spreadsheet from http://www.get-digital-help.com/2010...-in-excel-udf/. When I paste large amounts of data (several thousand, for instance) into column A, the arrays in the adjacent columns return a #VALUE error. In order to avoid this calculation update problem and in order to keep down the size of the spreadsheet, I wrote a VBA macro to input the arrays into the appropriate columns after column A is populated and then to copy/paste the array result Values Only. While the SplitWords function is working well, the other functions are returning a Type Mismatch error. The "Edited with VBA Code" spreadsheet is the spreadsheet that I added my VBA code to. Thank you for any help you can provide. Because the problem is in the function, I am having a difficult time troubleshooting the issue because I can't step through the functions with F8 as I do with subroutines.
Bookmarks