oh I C... My problem was that my sheet name had a space in it so the '' ' around the sheet name was required... my bad for not giving you the specifics... thanks for all your help guys really appreciate it.

Cheers