tommy1234
03-28-2010, 04:29 AM
Hello
I wrote a long formula in excel and i want to save time by insert it with code.
The formula is :
"=IF(ISERROR(VLOOKUP($A73,Sheet1!$A$1:$M$173,10,0))=TRUE,0,VLOOKUP($A73,Shee t1!$A$1:$M$173,10,0))"
What should i write in order to insrt it by code ?
Help is needed
Thanks
I wrote a long formula in excel and i want to save time by insert it with code.
The formula is :
"=IF(ISERROR(VLOOKUP($A73,Sheet1!$A$1:$M$173,10,0))=TRUE,0,VLOOKUP($A73,Shee t1!$A$1:$M$173,10,0))"
What should i write in order to insrt it by code ?
Help is needed
Thanks