I'm finding that I receive Run-time error 5941 if there are more than 2 rows containing the text 'Tree Number'. As if the code only handles the error once. I need the sub-routine to be able to split the table as many times as it finds the text. Hope this makes sense.
Thanks.
|