S
sb1222
Hi,
I'm having problems with concatenating string variables together.
This code works:
Dim text As String
Dim front As String
Dim middle As String
Dim back As String
Dim formula As Variant
text = Mid(ActiveCell.formula, 2)
front = "=IF(ISERROR(" & text
middle = "),'N/A'," & text
back = ")"
But, this piece does NOT work:
formula = front& middle & back
I get an compiling error expecting an end of a statement.
Any thoughts?
Thanks
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
I'm having problems with concatenating string variables together.
This code works:
Dim text As String
Dim front As String
Dim middle As String
Dim back As String
Dim formula As Variant
text = Mid(ActiveCell.formula, 2)
front = "=IF(ISERROR(" & text
middle = "),'N/A'," & text
back = ")"
But, this piece does NOT work:
formula = front& middle & back
I get an compiling error expecting an end of a statement.
Any thoughts?
Thanks
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***