Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
C.Value #N/A
I have code in my spreadshhet that goes through a range of cells and if they
are not blank it holds the value and not the formula: If c.value < "" then c.value = c.value Next This works perfectly however I have changed my formula in the spreadsheet to show #N/A instead of "". How do I convert this in the code to say - "if the cell value is not #N/A then c.value = c.value"? |