Results 1 to 2 of 2

Number of Rows or Columns count

Threaded View

  1. #1
    Registered User
    Join Date
    05-23-2012
    Location
    Toronto, ON, Canada
    MS-Off Ver
    Excel 2007
    Posts
    1

    Number of Rows or Columns count

    Hi am trying different methods to count rows or columns in given data set, without knowing last row or columns #

    these two lines doesn't worj
    i=range("A1").offset(1,0).end(xldown).rows.count
    i= range ("A2").end(xldown).rows.count
    this work fine

    i=range("A1").currentregion.rows.count
    can you please help with first two lines.
    Last edited by Cutter; 07-20-2012 at 11:40 AM. Reason: Added code tags

Thread Information

Users Browsing this Thread

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

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