Hi everyone.


The Runtime error: 13 seems to have, strangly, cured itself and I am unable to duplicate it.
Ihave not changed the code or the dataset.


I have attached a link to an example workbook to this post which uses dummy data, mostly fruit and various varieties, all obtained from various websites and the important colums that must match moving down the worksheet, A, B, I, J, are intact regardless of the dummy data.

Its in a 3.4 mb zip file so I am unable to upload as a file here.

https://drive.google.com/file/d/1yJd...ew?usp=sharing



I have added two extra colums, L & M.
In my original worksheet I only used Column K to host the value from my formula to VBA conversion.


I wanted a side-by-side comparason while testing so it now works like this...
Column K = original formula
Column L = why georgiboy's Code
Column M = My original code


georgiboy's code works perfectly, and fast, except for when it gets to Row L21425 and it fills every cell going down with "#N/A" as my original does. The VBA itself does not give any error except from entering "#N/A" in the cells.


I know in my original post I mentioned this error but in the example workbook I am using all new data so that rules out a data error. I am at a loss as to why georgiboy's Code and my own produces this error at the same row number.

I am wondering is this might be a virtual memory limitation.


If you are kind enough to take a look at the Example worksheet, you will see that I have left comments for myself in the VBA. I do this as I work to remind myself of issues and so on.

Thanks