+ Reply to Thread
Results 1 to 3 of 3

activesheet.usedrange.rows.count

  1. 06-12-2015, 07:37 AM #1
    kisanvikas2015
    kisanvikas2015 is offline
    Registered User
    Join Date
    04-14-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    127

    activesheet.usedrange.rows.count

    Hi everyone,

    I am new to VBA world. I saw a code in one of the existing excel file at office.
    I want to understand the use of activesheet.usedrange.rows.count

    Thanks in advance for any help!

    Regards,
    Vikas
    Reply With QuoteRegister To Reply
  2. 06-12-2015, 08:22 AM #2
    Jakobshavn
    Jakobshavn is offline
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: activesheet.usedrange.rows.count

    Activesheet.usedrange is a Range. A Range is a group of cells on a single worksheet. Many Ranges are nice rectangular blocks of cells, but some are not. Activesheet.usedrange is that block of cells that are used on the active worksheet.
    Gary's Student
    Reply With QuoteRegister To Reply
  3. 06-12-2015, 09:34 AM #3
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: activesheet.usedrange.rows.count

    In addition it gives a row value to the last cell in the Usedrange.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] LastRow = ActiveSheet.UsedRange.Rows.Count not givng correct value
    By BobBlooms in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2012, 02:02 PM
  2. Type Mismatch - ActiveSheet.UsedRange
    By LB79 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-28-2009, 08:22 AM
  3. ActiveSheet.UsedRange.Rows.Count
    By Kjaer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2007, 05:51 AM
  4. [SOLVED] selecting ActiveSheet.UsedRange
    By Gary''s Student in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-12-2006, 11:35 AM
  5. [SOLVED] how to reset the activesheet usedrange value
    By Gary Keramidas in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-28-2005, 11:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1