Dear All ,

I have stored macros in workbook 1 , i have create macro to use vlookup function in the same sheet.

when i am trying to run same macro in other open work book , it request for update value , & i had to give reference to the workseet where original macro is stored

any idea about it ....


Thanks
A