On 28 Mar, 15:41, "Jim Rech" wrote:
Try using RefersTo rather than RefersToR1C1.

--
Jim

Hi Jim,

Thanks for such a quick response, I hadn't really expected one so
fast.

The suggestion you made fixed it, I must say thank you a lot as I have
made my job a lot easier with the above macro.

Thnx so much! who would've thought it'd be so simple!

--Phil