| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display WorkSheet data Size
Hi,
Does anybody know if there is a way to determine how much data is one individual sheets in a workbook? Something along these lines? Sub CountWS() Dim W As Worksheet For Each W In Workbooks W.Count End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display WorkSheet data Size
it's OK, i found something that was very helpful.
http://www.mvps.org/dmcritchie/excel/saveas.htm spences10 wrote: Hi, Does anybody know if there is a way to determine how much data is one individual sheets in a workbook? Something along these lines? Sub CountWS() Dim W As Worksheet For Each W In Workbooks W.Count End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 1 worksheet to display data from many | Excel Discussion (Misc queries) | |||
| Display data from another worksheet | Excel Discussion (Misc queries) | |||
| How do I display every 5th row of data from a worksheet in a new . | Excel Worksheet Functions | |||
| how do i filter data on one worksheet and display on another. | Excel Discussion (Misc queries) | |||
| How do I display data in different worksheet in excel | Excel Discussion (Misc queries) | |||
Linear Mode
