Thread: Excel VB issue
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vee vee is offline
external usenet poster
 
Posts: 12
Default Excel VB issue

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