Hi everybody, I formatted my computer and since then vba functions are not working. Before the format I used excel 2010 and everything worked great (vba functions), but after formatting I installed excel 2013 and it started.
When I create a function in vba (anyone), and after that I use the function in the spreadsheet it always returns the same error: #VALUE!
For example: I introduced this code in vba:
Function inandout(x, y)
inandout = x + y
End Function
after that I tried to use the formula for 5,2 = I wrote in the bar: =inandout(5,2)
and it gives me the error: #VALUE!
That happens with all the function while before formatting it didn´t happen. I´ve already tried uninstalling the 2013 version and installing again the 2010, but it happens in this version too. Macros are allowed and the document is saved as a xslm. Could you help me to fix this?
Thank you so much in advance
When I create a function in vba (anyone), and after that I use the function in the spreadsheet it always returns the same error: #VALUE!
For example: I introduced this code in vba:
Function inandout(x, y)
inandout = x + y
End Function
after that I tried to use the formula for 5,2 = I wrote in the bar: =inandout(5,2)
and it gives me the error: #VALUE!
That happens with all the function while before formatting it didn´t happen. I´ve already tried uninstalling the 2013 version and installing again the 2010, but it happens in this version too. Macros are allowed and the document is saved as a xslm. Could you help me to fix this?
Thank you so much in advance