Hello!
Is there any way I can test for a #VALUE! entry in a spreadsheet either through a line of VBA code or an IF statement in a cell?
IE: A1 = #VALUE!
Could cell B1 have something similar to: IF(A1='#VALUE!',1,0)
(Although I know this won't work!)
or a VBA function when I run a macro?
Thanks!
Bookmarks