LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
1 worksheet to display data from many Dave Eade Excel Discussion (Misc queries) 1 March 20th 09 01:00 PM
Display data from another worksheet Don Excel Discussion (Misc queries) 2 October 29th 08 01:48 AM
How do I display every 5th row of data from a worksheet in a new . jct Excel Worksheet Functions 2 February 22nd 07 01:38 AM
how do i filter data on one worksheet and display on another. excellent Excel Discussion (Misc queries) 1 June 22nd 06 12:15 PM
How do I display data in different worksheet in excel Hedgelayer2 Excel Discussion (Misc queries) 1 February 13th 06 03:34 AM


All times are GMT +1. The time now is 09:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"