Quote Originally Posted by xld
That suggests to me that there is no data in the workbook. Can you post it?
No indeed, (said that under the code i posted before)

Basically so far it's just the function i posted above and a subprocedure to test it the function..

(if you might be wondering why i'm not just inserting the data first, its because we have to follow the steps in order to make the whole 'task')