+ Reply to Thread
Results 1 to 3 of 3

Fast way to hide rows (alternative from Looping)

  1. 04-05-2017, 01:05 AM #1
    lexusap
    lexusap is offline
    Forum Contributor
    Join Date
    08-16-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2019
    Posts
    209

    Fast way to hide rows (alternative from Looping)

    Hi,

    I am currently trying to hide rows based on value in column C - which are 1 = show, 0 = hide, no value = show.
    Current code using looping will take forever as we have thousands of GL codes across multiple spreadsheet - just wandering if there is a fast way to hide and show rows?

    Below is my code.

    Please Login or Register  to view this content.
    Thanks
    Al
    Attached Files Attached Files
    Last edited by lexusap; 04-12-2017 at 11:42 PM.
    Reply With QuoteRegister To Reply
  2. 04-05-2017, 01:15 AM #2
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Fast way to hide rows (alternative from Looping)

    can you not just autofilter or advanced filter?
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 04-05-2017, 01:17 AM #3
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Fast way to hide rows (alternative from Looping)

    AutoFilter with no drop down
    Please Login or Register  to view this content.
    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] Alternative to looping through columns
    By Jessica.Bush in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-27-2014, 10:21 AM
  2. [SOLVED] Fast macro to hide empty rows
    By Joak in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-22-2014, 05:04 PM
  3. Fast Index/Match Alternative in VBA
    By RS15 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-10-2014, 02:41 PM
  4. Alternative Method for Countif, without Looping
    By cmore in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-03-2013, 04:50 PM
  5. Fast way to hide all pivot items in VBA?
    By Air_Cooled_Nut in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2013, 10:27 AM
  6. any alternative method for looping?
    By dan2010 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-18-2010, 06:43 AM
  7. Need a fast way to delete rows
    By glenlee in forum Excel General
    Replies: 1
    Last Post: 09-23-2005, 12: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