Hi
I have a macro in one workbook. I want to run it via cells function (=xxxxx(cellref) ) but because it is in another workbook excel cannot see it.
Whats the way to specify to call it from the other workbook?
Hi
I have a macro in one workbook. I want to run it via cells function (=xxxxx(cellref) ) but because it is in another workbook excel cannot see it.
Whats the way to specify to call it from the other workbook?
Nevermind - got it... My vba had errored... works fine ('macros'!macroname(cellref) )