Kevvukeka,
Analyzing snb's code is always a treat.
Put his code in any VBA code page and place the cursor in the last dotted keyword, (ex: .SpecialCells,) in a line of code and press F1 for help on that Keyword.
Proceed with Keywords from Right to left.
Pay close attention to Parenthesis and commas. (ex:the first [,"|")] belongs to "Join".)
Open NotePad, paste a code line in it and format the line with CR's and tabs.
Reply With Quote