Thanks for ur codes....Im having problems when I need to use it over a pivot table which is "protected". It needs to be.. coz I do not want users to make changes to it..Anyway,thanks for ur help n if I have any prob on the way, I'll get back to u buddy..
Cheers
ITboy