Hello Fredlo!
Thank you. This is very strange. When I run my original code, I get "Value!" in the cell where I run "test2()". I'm running MS Excel 2010 on Windows 7 Home Premium in a Parallels 9 Desktop environment on OS X 10.7.5. What OS are you using?

I've a very long function and at the end of it, I'm trying to write values in an Excel sheet. The rest of the function works fine - I've tested it through break points. Now, I'm at at the last step - trying to write the computed values onto the excel sheet cells. And am stuck!