Call function in other excel sheet.

[krishnarao]

In my excel sheet, I have a function in Code module which i use as formulea in my sheet.

What I want to do now is access this function in other opened excel sheets as formulea. How can this be done?

Thanks In Advance.

[ChemistB]

I assume you have this function in another workbook (e.g. personal.xls)? In that case, you need to include the name of that workbook when calling the function. For example if your function is in personal.xls and it's called ColorCd

Please Login or Register  to view this content.

Does that answer your question?

[krishnarao]

Yes. it worked.

Thanks..