I paste a file containing the names of departments and data regarding them
into a worksheet. I run a macro to sort and move each department's data into
their own worksheets. Some departments may not have data moved to their
worksheet (this is a good thing). If their worksheet (i.e. C2) is blank, I
would like the macro to say "Congratulations! You do not have any Negative
reports for this period". I'm having trouble developing the IF statement.

TIA,
Carole O

hi
lot of ways to do this. heres one
Sheets("sheet2").Activate
If Range("A1") = "" Then
Range("A1").Value = "Congratulations! You do not have any Negative
reports for this period."
End If

regards
FSt1

"Carole O" wrote:

I paste a file containing the names of departments and data regarding them
into a worksheet. I run a macro to sort and move each department's data into
their own worksheets. Some departments may not have data moved to their
worksheet (this is a good thing). If their worksheet (i.e. C2) is blank, I
would like the macro to say "Congratulations! You do not have any Negative
reports for this period". I'm having trouble developing the IF statement.

TIA,
Carole O

Thank you so much! That is exactly what I wanted to do!

Carole O

"Carole O" wrote:

I paste a file containing the names of departments and data regarding them
into a worksheet. I run a macro to sort and move each department's data into
their own worksheets. Some departments may not have data moved to their
worksheet (this is a good thing). If their worksheet (i.e. C2) is blank, I
would like the macro to say "Congratulations! You do not have any Negative
reports for this period". I'm having trouble developing the IF statement.

TIA,
Carole O