On Sunday, 9 September 2012 19:53:38 UTC+1, (unknown) wrote:
Taffy,



I think the issue is in the "SourceData" argument. If you change it to:



SourceData:="Sales!" & Worksheets("Sales").Range("A5").CurrentRegion.Addr ess



it should work.



Hope this helps,

Ben

Hi Ben,
Thanks for your help - it worked a treat! I'm always amazed at how quick you guys post your responese.

Thanks again,

Taffy