VBA - Hide rows by filter insted of loop.

**countryfan_nt** · 06-15-2017, 04:50 PM

Hello friends, Hope all is well!

The below code works well and smoothly. But it's slow.
Can you please help me modify it by making the code filter and hide the rows in column R8:R94 if the cells = 0.

Thank you very much in advance!

Please Login or Register  to view this content.

**TMS** · 06-15-2017, 04:56 PM

If it's a fixed range, why don't you just record a macro?

VBA - Hide rows by filter insted of loop.

LinkBack

Thread Tools

Rate This Thread

Display

VBA - Hide rows by filter insted of loop.

Re: VBA - Hide rows by filter insted of loop.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Loop through every second row and hide rows based on cell values

[SOLVED] Extra rows being hidden in loop to hide rows

Loop to hide rows containing a value

Problem with Loop Macro to Hide Rows.

Hide Rows Without Filter Arrows

Loop through a range to hide rows

[SOLVED] changing rows insted of columns

Bookmarks

Bookmarks

Posting Permissions