Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I want to use a function from the excel COM object to determine that an
excel sheet is empty of any cells, charts, or other elements. Some sheets have no cells but can have other elements like lines or pictures not related to a cell. For instance, say someone wants to reference the COM print for each sheet in a standard excel worksheet, created with the Sheet1, Sheet2, Sheet3 default, but with sheet 1 having some cells, sheet two having just a picture or chart, and sheet three not used. I want to print sheet one and two, but not three. How can the program use the COM object to know that sheet 3 is TOTALLY empty regardless of excel version? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I import a website into my excel sheet automatically ever. | Excel Discussion (Misc queries) | |||
How do I stop an Excel sheet from automatically hiding rows when . | Excel Worksheet Functions | |||
in excel, how do i set up a spread sheet that automatically total. | New Users to Excel | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |