I posted this before and got an answer using filters but it just does not work for what I am looking to do to hide rows

Status
Not open for further replies.

alan myers

Board Regular
Joined
Oct 31, 2017
Messages
119
Office Version
  1. 365
Platform
  1. Windows
Hidden y/nStartEnd
carrier 1y350
carrier 2n6070
carrier 3n89100
carrier 4n121125
carrier 5y330400
carrier 6y450526
carrier 7n551589
carrier 8y602703
Carrier 194n899945
Carrier 195y########
this Is the h-show tab
I want to hide rows on the cover sheet tab
there are 195 Carriers
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Are we to assume we are looking at columns A B C and D

And if column B has "y" you want that row Hidden? Is that correct?
And do you want the script to run when you press a button or when you enter a "y" in a cell in column B

And how do you plan to unhide the row?
 
Upvote 0
Duplicate to: tp hide or not

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,214,986
Messages
6,122,611
Members
449,090
Latest member
vivek chauhan

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