Hello,
I am using VBA loop to get value from range.
Most of cells have values, but some cells has #NUM error.
VBA works fine until first #NUM error.
How can I ignore or make it copy "This cell has error" text instead of #NUM ?
I am using VBA loop to get value from range.
Most of cells have values, but some cells has #NUM error.
VBA works fine until first #NUM error.
How can I ignore or make it copy "This cell has error" text instead of #NUM ?
VBA Code:
sld.Shapes("$element4").TextFrame.TextRange.Text = Sh.Range("F80").Offset(0, i).Value