batman1,
Interesting approach and while I am close to making it work, the actual file is much larger and more complicated than my simple example.
Two things:
1. There is not always a match. So when I run your code, Count and Ubound(result) are not the same.
2. So, I think that is why I get error about subscript out of range with Resize(count, 5).
I can't upload the file here. It is too big. You can get it at the cross post link if your want to look.
|