Hide rows and count visible cells only

pwill

Active Member
Joined
Nov 22, 2015
Messages
406
Hi can anyone help with a macro that will hide rows one at time starting from the last row used on sheet2 ("A:Z).
And a second macro to unhide the last rows one at a time.

Then have this formula on sheet1("T5") count only visible cells on sheet2.

=COUNTIF('Sheet2'!B:H,$S5)

Any help would be appreciated

Regards

pwill
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Watch MrExcel Video

Forum statistics

Threads
1,102,302
Messages
5,486,052
Members
407,529
Latest member
netojose

This Week's Hot Topics

Top