+ Reply to Thread
Results 1 to 3 of 3

Code amendment request to hide all rows at the end

  1. #1
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Code amendment request to hide all rows at the end

    Hi friends,
    I want to hide all rows offset 2 at the end of data. Now the code is hiding only 1 row which I want to hide all rows.

    For example:
    If the data is on row 6 then I want to leave a blank row and hide all the rows till the end. In this case the rows from 8 to the end should be hidden.

    Row 6 last data entry
    Row 7 leave blank unhidden
    Rows from 8 to end should be hidden

    Please Login or Register  to view this content.
    Thanking you,
    Sincerely,

    mso3

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Code amendment request to hide all rows at the end

    You were close. The syntax for what you are wanting to do can be a little tricky.

    Please Login or Register  to view this content.
    Last edited by stnkynts; 08-03-2015 at 09:20 PM.
    If you are happy with my response please click the * in the lower left of my post.

  3. #3
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Code amendment request to hide all rows at the end

    Perfect! The tricky code is working fine.

    I appreciate you for the same.

    Thank you and have a nice time.

+ 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. [SOLVED] Formula amendment request for month and year
    By mso3 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-01-2015, 10:46 PM
  2. Amendment to code: automatically insert rows if needed
    By phbryan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2014, 11:30 PM
  3. Request for VBA code to compare loumns to rows
    By genetist in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-09-2013, 12:51 AM
  4. Code Amendment - Delete Empty Rows
    By TextMonkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2013, 08:03 AM
  5. VB code amendment help.
    By sem in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 04-26-2012, 07:23 AM
  6. if code amendment help
    By khalid79m in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2008, 07:27 AM
  7. Hide Rows meeting condition Amendment
    By Robert in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2006, 08:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1