no worries ppl...i have come up with an alternative solution....just moved the code from the module onto the current worksheet and it seems to have done the trick.....thanks aneways

cheers