Question:
Hi
I need to be able to convert the value "#" to "0" for a single column in my BEX worksheet? I know how to do it for the whole worksheet using this code
Sub SAPBExonrefresh(queryID As String, resultArea As Range)
For Each c In resultArea
If c.Value = "#" Then
c.Value = ""
End If
Next
End Sub
Answer:
If you know the number of the column, easy
For Each c In resultArea.columns(number)
If c.Value = "#" Then
c.Value = ""
End If
Next
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.