Sorry Tom, just a further question, i am also using your code to copy
over a date in the format 20070223, but on the KTL sheet where it gets
copied to the cell format is set as "dd-mmm-yy" and when it copies it in
it just shows ################ is there a way around this ??

Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***