Doesn't work with or without parenthesis?
I'm trying to create a formula to increment a counter. The variable name
contains a variable.
sCt = "A"
If rCell = "16" Then
sCt = rCell.Offset(, 2).Value
"l16" & sCt & "ct" = "l16 " & sCt & "ct" + 1
End If
It's turning red on me. I want it to yield
l16ACt = l16ACt + 1
That is "el sixteen Ay cee tee"
Does anyone know how to enter this?
Thanks!
|