Excel VB issue

[Vee]

I am checking a cell to see if it is blank or populated. For some reason it
is not recognizing my "if" statement that = "" or <>"". Below is the code:

If Range("B13").Formula = """" Then
Range("A12:A23").Select
Selection.Copy
Sheets("DetailFinal").Select
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=True
Sheets("Worksheet").Select
End If

 

[Gary''s Student]

If Range("B13").Value = "" Then

 

[Bob Phillips]

Don't bother with the selecting

If Range("B13").Value = "" Then
Range("A12:A23").Copy
Sheets("DetailFinal").Range("A2").PasteSpecial Paste:=xlPasteAll, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=True
End If
Application.CutCopyMode = False

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[TomPl]

I like:

If IsEmpty(Range("B13") then