Posted By: Anonymous
The problem is that
!= does not work as a function in excel vba.
I want to be able to use
If strTest != "" Then instead of
If strTest = "" Then
Is there another approach to do this besides
My function to mimic
Sub test() Dim intTest As Integer Dim strTest As String intTest = 5 strTest = CStr(intTest) ' convert Range("A" + strTest) = "5" For i = 1 To 10 Cells(i, 1) = i If strTest = "" Then Cells(i, 1) = i End If Next i End Sub
Because the inequality operator in VBA is
If strTest <> "" Then .....
!= is used in C#, C++.