+ Reply to Thread
Results 1 to 3 of 3

counting the number filled rows in excel

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    36

    counting the number filled rows in excel

    For m = 2 To 40

    With Sheets("EEA Referral Tracker").Cells(3, m)
    If .Value <> "" Then tu = m

    End With
    Next m


    I tried to count the number of rows which are filled using this until the last column. But this doesn’t work. Can u help me in this.

  2. #2
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: counting the number filled rows in excel

    Deleted as the OP isn't using code tags. Will re-post once corrected
    Last edited by WasWodge; 02-11-2014 at 07:23 PM.
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

  3. #3
    Registered User
    Join Date
    02-06-2014
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    36

    Re: counting the number filled rows in excel

    How to delete ??

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Generate Columns depending on the number of rows filled(VBA / BDH function)
    By bryan444 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-29-2012, 04:27 AM
  2. Replies: 12
    Last Post: 07-10-2012, 05:04 PM
  3. Replies: 7
    Last Post: 08-15-2009, 09:09 AM
  4. [SOLVED] Counting filled cells in excel
    By Alex Wilson in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-19-2005, 06:05 PM
  5. How to determine number of rows that are filled?
    By ljCharlie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2005, 02:56 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1