How do I create a code that forces specific cells to show or return N/A is they are left blank or empty?
This is the code that I created but it only works if all cells are left empty. I want them to work in such a way that if one, or two, or three or all of the cells are empty it will return/show N/A in it.
VB.Net
-----------------------------------------------
Sub CopyEvenEmptyCell()
''''''''''''''''''''''''''''''''''''''''''''
'Forces cell to show N/A if blank
''''''''''''''''''''''''''''''''''''''''''''
Dim isMyCellEmpty As Boolean
isMyCellEmpty = IsEmpty(Range("C3,E3,C4,E4"))
If isMyCellEmpty = True Then
Range("C3,E3,C4,E4").Value = "N/A"
End If
'
'
' This copies your ICMS Documentaion to the clipboard. :)
'
'
Range("B3:E6").Select
Selection.Copy
End Sub
--------------------------------------------
Display More