Post the code that you are using. Code like the following should
work:

If Range("A1").Value < "" Then
' A1 has something in it
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"nic17 " wrote in message
...
Thanks for your help,

I have tried both of these suggestions, but neither work! I've
also
tried below:

<""
<" "
< ""
< " "
!=""
!=" "

It's such a simple task, so why does this not work??


---
Message posted from http://www.ExcelForum.com/

Below is the macro that I have set up:

Application.ScreenUpdating = False
Sheets("MTHDATA").Visible = True
Sheets("Criteria2").Visible = True
Sheets("Criteria2").Select

Range("datainput").AdvancedFilter Action:=xlFilterCopy
CriteriaRange _
:=Range("critrep1"), CopyToRange:=Range("report1")
Unique:=True

Sheets("Macro").Select
Range("C5").Select
Application.ScreenUpdating = True
End Sub

The criteria this is reading from is:

Report1 Incomp
< "0"

It should then dump this into 'report 1'.

This has worked for all the other reports

--
Message posted from http://www.ExcelForum.com