Hi,

I tried the "Application.EnableEvents" method, but it gave me the erro
1004 "select method of range class failed"

let me try explaining it again:

there is this first macro(1st) which doesnot let anyone select th
cells in the area b2:c2001 and there is another macro(2nd) which want
to copy the contents in the same area and paste the values (past
specialvalues) in that area, but the 1st one doesnt allow .........

i hope i have explained the problem clearly now.....

thanks again for replying!!

--
Message posted from http://www.ExcelForum.com