isblank macro

  • Thread starter Thread starter Carole O
  • Start date Start date
C

Carole O

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro needed to copy groups of data from one spreadsheet to anothe 1
Need Macro... 8
Macro to merge worksheets 1
Data Extract from Multiple Worksheets Macro 4
Getting a macro to work in all workbooks 10
Print Macro 1
Select and copy certain tabs using macro 7
Ask for date 3

Back
Top