code for executing Bloomberg BDH function in the middle of a macro

[xcelnovice101]

I'm hoping someone is familar with Bloomberg excel functions in VBA. My below code doesn't debug but the results it provides in my cell is: "#N/A N Ap"

Any help would be greatly appreciated.

Please Login or Register  to view this content.

[AlphaFrog]

Remove the .Value from this line.

finalDate = CLng(Evaluate("=IF(E2<>"""",E2,B3)").Value)

[xcelnovice101]

I get the same results AlphaFrog