unhide next X rows where X=((RC-2)-1)...?

blist

New Member
Joined
Mar 11, 2004
Messages
20
What VBA will allow me to select a cell in F:F, which will unhide the next X amt of rows where X is the value of ((RC-2)-1)...?
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Watch MrExcel Video

Forum statistics

Threads
1,108,492
Messages
5,523,260
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top