Ok. Here's my problem. I have a spreadsheet that I use which filters on 6 different filter criteria and copies the result set of each filter criteria to a separate worksheet. However, on occasion there are no results found for a given criteria.
What I want to do is when no results are found for a given criteria to return the words "No Data Found" to a cell on a different spreadsheet.
I'm trying to find the correct syntax for:
If SpecialCells = "" then
Sheet("Smith").Select
Range("C2").Select
ActiveCell.FormulaR1C1 = "No Data"
I do know that SpecialCells represents Filtered Records but that's about all I know what to do with that.
Any ideas?
Thanks guys.