Lucas, thanks for that and it looks very useful and i will keep that for future use however i need to determine the actual area eg "A1:Gxx" where it will always be A1 but the following address is variable, i could of course specify the actual range but it will alwas be a count of used rows in column A so column A including blanks = 50 then the range must be A1: & Last Used Column & 50.

Regards,
Simon