Cheers Greg.
Unfortunately when run most of the time now it gives an Invalid use of Null (Error 94), relating to the line:
strID = Arr(0, iCols)
The search value and Excel workbook meet the requirements so I'm not exactly sure where this is coming from.
|