Refer to a dynamic workbook in formula

Hi,

I have been searching hi & low to solve this on my own. I am @ my whits end. I want to point @ a specific workBooks that I have open or am opening in the code.

I am trying to do this as a VBA formula that I fill down a Column.

Please Login or Register  to view this content.

Any help offered is much appreciated.

Thanks,

dlow :D

The specific error I get is: Application-defined or object-defined error.

Tennis anyone?

Still have this problem & hoping someone might be able to help me out. If I get it worked out I will post back results.