I wonder if someone could help. I have the following VBA code:
Sub Rectangle1_Click()
Name = "Mike"
Cells(4, 4) = "=if(a=1," & Name & ",2)"
End Sub
What I want it to give when I run it is:
=If( a=1, "Mike",2)
What I get is
=If( a=1, Mike,2)
i.e. it's looking for a range name called Mike.
Thanks,
MikeG
Sub Rectangle1_Click()
Name = "Mike"
Cells(4, 4) = "=if(a=1," & Name & ",2)"
End Sub
What I want it to give when I run it is:
=If( a=1, "Mike",2)
What I get is
=If( a=1, Mike,2)
i.e. it's looking for a range name called Mike.
Thanks,
MikeG