Excel Help.xlsm
If you see the original "test 2" that I wrote, test 2 = 1#, so, yes, the function is returning a double. So, I expect to see 1.0 in the cell on the Excel sheet where typed in "=test2()". Unfortunately, I see "Value!".

I need to use the format Cell(a,b).Value not Range("a1") format as I change the cell values through a loop [Post 1, see Sub Write 2()].

I've attached the excel sheet below. Please advise if you can see it or if I should email it directly to you?
In the sheet, I've highlighted the cells as red and put a " ' " before the functions to prevent them from running before you have had an opportunity to view the file.