| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Sh as Worksheet
Hi,
I'm a newbie and as having trouble grasping something. I'm running code to delete all empty sheets in a workbook. The code I have found begins with Dim sh as Worksheets For Each sh in ThisWorkbook.Worksheets If Application.WorksheetFunction.Counta(sh.cells) = 0 Then application.DisplayAlerts = False sh.Delete Application.DisplayAlerts=True End if Next My questions is: What does the sh as Worksheet mean in plain English? I assume the Displayalerts means don't show me the confirmation message to delete sheets Thanks! -- Thanks! Dee |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HELP! Sh as Worksheet
Hi,
You are assigning a variable for referencing the sheets in the workbook. You could just as easily say; For each sht in ThisWorkbook.Worksheets. You can assign whatever you would like. Think of it as a quick way to reference the sheets. Look up variables in the help file. Yes, the display alerts does what you think it does. HTH, Job "dee" wrote in message ... Hi, I'm a newbie and as having trouble grasping something. I'm running code to delete all empty sheets in a workbook. The code I have found begins with Dim sh as Worksheets For Each sh in ThisWorkbook.Worksheets If Application.WorksheetFunction.Counta(sh.cells) = 0 Then application.DisplayAlerts = False sh.Delete Application.DisplayAlerts=True End if Next My questions is: What does the sh as Worksheet mean in plain English? I assume the Displayalerts means don't show me the confirmation message to delete sheets Thanks! -- Thanks! Dee |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HELP! Sh as Worksheet
It means you are telling vba you are going to use a variable named Sh in the
code which is of type Worksheet For the DisplayAlerts, you' re right. Sebastien "dee" wrote: Hi, I'm a newbie and as having trouble grasping something. I'm running code to delete all empty sheets in a workbook. The code I have found begins with Dim sh as Worksheets For Each sh in ThisWorkbook.Worksheets If Application.WorksheetFunction.Counta(sh.cells) = 0 Then application.DisplayAlerts = False sh.Delete Application.DisplayAlerts=True End if Next My questions is: What does the sh as Worksheet mean in plain English? I assume the Displayalerts means don't show me the confirmation message to delete sheets Thanks! -- Thanks! Dee |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HELP! Sh as Worksheet
Hi,
Thank you both for your responses. I guess I don`'t understand why I can't refer to the worksheet objects directly. In other words, why do I have to assign a variable? I guess I need lots of work in this area to understand it clearly, but with the valuable help from people like you, I will eventually get it! Thanks! "Job" wrote: Hi, You are assigning a variable for referencing the sheets in the workbook. You could just as easily say; For each sht in ThisWorkbook.Worksheets. You can assign whatever you would like. Think of it as a quick way to reference the sheets. Look up variables in the help file. Yes, the display alerts does what you think it does. HTH, Job "dee" wrote in message ... Hi, I'm a newbie and as having trouble grasping something. I'm running code to delete all empty sheets in a workbook. The code I have found begins with Dim sh as Worksheets For Each sh in ThisWorkbook.Worksheets If Application.WorksheetFunction.Counta(sh.cells) = 0 Then application.DisplayAlerts = False sh.Delete Application.DisplayAlerts=True End if Next My questions is: What does the sh as Worksheet mean in plain English? I assume the Displayalerts means don't show me the confirmation message to delete sheets Thanks! -- Thanks! Dee |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HELP! Sh as Worksheet
Thanks! I think I got it!
Thanks to you both! "Job" wrote: Hi, You are assigning a variable for referencing the sheets in the workbook. You could just as easily say; For each sht in ThisWorkbook.Worksheets. You can assign whatever you would like. Think of it as a quick way to reference the sheets. Look up variables in the help file. Yes, the display alerts does what you think it does. HTH, Job "dee" wrote in message ... Hi, I'm a newbie and as having trouble grasping something. I'm running code to delete all empty sheets in a workbook. The code I have found begins with Dim sh as Worksheets For Each sh in ThisWorkbook.Worksheets If Application.WorksheetFunction.Counta(sh.cells) = 0 Then application.DisplayAlerts = False sh.Delete Application.DisplayAlerts=True End if Next My questions is: What does the sh as Worksheet mean in plain English? I assume the Displayalerts means don't show me the confirmation message to delete sheets Thanks! -- Thanks! Dee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
| copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
| Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming | |||
Linear Mode
