| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Macro
Is there a macro that will say if Column A and Column B on Sheet3 have
contents follow this code€¦ I am going to put a long code here But if Column A and Column B do not have contents follow this code application.displayalerts = false Sheets("Sheet3").Delete Sheets("Sheet3a").Delete application.displayalerts = true End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If Macro
try
Sub ifcolaandbblank() If WorksheetFunction.CountA(Columns("a:b")) 0 Then 'do this Else On Error GoTo nono Application.DisplayAlerts = False Sheets("sheet3").Delete Sheets("sheet3a").Delete Application.DisplayAlerts = True End If Exit Sub nono: MsgBox "not there" End Sub-- Don Guillett Microsoft MVP Excel SalesAid Software "Sal" wrote in message ... Is there a macro that will say if Column A and Column B on Sheet3 have contents follow this code€¦ I am going to put a long code here But if Column A and Column B do not have contents follow this code application.displayalerts = false Sheets("Sheet3").Delete Sheets("Sheet3a").Delete application.displayalerts = true End Sub |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If Macro
This is really good stuff. Thank you very much.
"Don Guillett" wrote: try Sub ifcolaandbblank() If WorksheetFunction.CountA(Columns("a:b")) 0 Then 'do this Else On Error GoTo nono Application.DisplayAlerts = False Sheets("sheet3").Delete Sheets("sheet3a").Delete Application.DisplayAlerts = True End If Exit Sub nono: MsgBox "not there" End Sub-- Don Guillett Microsoft MVP Excel SalesAid Software "Sal" wrote in message ... Is there a macro that will say if Column A and Column B on Sheet3 have contents follow this code€¦ I am going to put a long code here But if Column A and Column B do not have contents follow this code application.displayalerts = false Sheets("Sheet3").Delete Sheets("Sheet3a").Delete application.displayalerts = true End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AutoRun Macro with a delay to give user the choice to cancel the macro | Excel Programming | |||
| Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor | Excel Programming | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Hybrid Mode
