Unhiding rows based on data input

  • Thread starter Thread starter Janelle S
  • Start date Start date
J

Janelle S

Is there any way to unhide a number of rows based on the number that the user
inputs. Eg. if user inputs 4 into cell p48 then i would like the 4 rows
immediately below row 55 to unhide.
Thanks in anticipation.
 
Hi Janelle. Yes there is a way, but you need macros VB for this. Any
experience?
 
Thanks Argy. Some experience, mostly through help via these posts. Any help
you could give would be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why do hidden columns/rows unhide automatically? 1
hide, unhide column or row after protect worksheet 4
Cannot unhide the hidden rows in my spreadsheet 3
How to Hide and Unhide Rows 2
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Macro: Unhiding a row daily 1
Enabling option „Format rows“ to hide/unhide rows using VBA-code? 0
Unhide columns and rows 2

Back
Top