Using IF statement to Call a subroutine

[LeepII]

Hi all. I would like to call a subroutine only if a cell on the active sheet is not empty.

So far I have tried the following:

Range("A2").Select
If R1C1 <> """" Then Call Subroutinename

If A2 <> """" Then Call Subroutiename

If LEN(R1C1) > 0 Then Call Subroutinename


None of them work. Either the sub runs all the time or never runs.

 

[VoG]

Try

If Range("A2").Value<>"" then Call subroutinename

 

[NeonRedSharpie]

If Cells(1, 1) = "" Then MsgBox "HELLO WORLD"

This will check is A1 is empty, and if it is, it will message (or add in subroutine).

 

[LeepII]

Thanks VoG, worked like a charm!