Thank you guys for your replies but the problem was that I declared it as a Range and was trying to "=" to a Worksheet, big heriarchichal no, no it seems I just took the worksheets part out and it worked fine

Until next question.....