Macro to unhide a row based on a value in previous row

W

werfair

New Member
Joined
Nov 10, 2017
Messages
3
I have several lines hidden but if there is a value >0 in B7 I need the Macro to unhide row 8. then if a value is in B8 I need it to unhide row 9 ect. can someone please help? Thank you for your time.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

F
  • Solved
VBA to Automatically Hide/Unhide Dynamic Range based Upon Cell Value
Replies
3
Views
337
franswa3434
F
edge37
  • Question Question
Toggle hide/unhide macro for a range of cells with values, borders and background colors.
Replies
1
Views
103
Alex Blakenburg
A
R
  • Question Question
Button to hide/unhide rows with specific text
2
Replies
11
Views
518
NoSparks
N
E
  • Question Question
VBA Code to hide/unhide rows when a something is selected from drop down list.
Replies
4
Views
419
Essencex
E
N
  • Question Question
Toggle code to hide and unhide columns based on text in a row
Replies
1
Views
522
Cubist
Cubist

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top