here is how my function looks like. Also i am using this in formula
like =check("A1")

function check(cell)
{
if cell50
get the new valuue from a differnt workbook
}


can someone PLZ tell me how will i get the value from a different
workbook. I have to use this value in my function, can this be done in
a macro. I can open the second workbook if need be . please help

You can reference the other workbook in the formula, =[Book1.xls]Sheet1!$A$1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

wrote in message
oups.com...
here is how my function looks like. Also i am using this in formula
like =check("A1")

function check(cell)
{
if cell50
get the new valuue from a differnt workbook
}


can someone PLZ tell me how will i get the value from a different
workbook. I have to use this value in my function, can this be done in
a macro. I can open the second workbook if need be . please help

is there anyway i can use it in my function rather than directly
putting in a formula bar. Its because the value to get is dynamically
fetched and my function is already taking care of other conidtions.


Paul B wrote:
You can reference the other workbook in the formula, =[Book1.xls]Sheet1!$A$1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

wrote in message
oups.com...
here is how my function looks like. Also i am using this in formula
like =check("A1")

function check(cell)
{
if cell50
get the new valuue from a differnt workbook
}


can someone PLZ tell me how will i get the value from a different
workbook. I have to use this value in my function, can this be done in
a macro. I can open the second workbook if need be . please help