Formula within an IF statement - VBA

[lloydie8]

Morning guys

A simple one for you experts, but not so simple for myself as a newbie to VBA.

I am trying to write =IF(H2="0",H2,"0"&H2) as part of a VBA string. However, whatever I try is returning #NAME !

Any ideas on how I should write this in VBA please folks?

Many thanks,
Gareth

 

[Special-K99]

So if H2 = 0 you return 0 otherwise you return H2 with a leading zero?
Try

Sub k1()
Dim var1 As String
If Range("H2") = "0" Then var1 = "0"
Else: var1 = "0" & Range("H2")
MsgBox var1
End Sub

You may need to replace "0" with 0 depending on the data (a common problem amongst newbies is to mix up 0 with "0")

 

[lloydie8]

Yep, that's right.

Seems to work for me, thank you.

So if H2 = 0 you return 0 otherwise you return H2 with a leading zero?
Try

Sub k1()
Dim var1 As String
If Range("H2") = "0" Then var1 = "0"
Else: var1 = "0" & Range("H2")
MsgBox var1
End Sub

You may need to replace "0" with 0 depending on the data (a common problem amongst newbies is to mix up 0 with "0")