Hi Mr.Bob,
It is working well,thanks alot. but another proble
comes that , I am getting the data from another source workbook(acces
analys data) this A1 has a paste special formula (from that workbook
after doing this , the formula disappearing. So each time i have to pu
the formula on cell A1.
one more thing if i am deleting the souce line in the other book th
new A2 cell is remaining with the characters . the formula is like thi
=MICR.xls!$N$2. Any solution.
Bob, no hurry at all , whenever you are getting time look on it.
by
nowfa

--
nowfa
-----------------------------------------------------------------------
nowfal's Profile: http://www.excelforum.com/member.php...fo&userid=1000
View this thread: http://www.excelforum.com/showthread.php?threadid=39553