Hi, great tutorial. Just a question though (I'm very new to this and basically have zero knowledge), what if I want to run this a hundred times, lets say every after 20 rows. How will I do that? Thanks
Conditional formatting "hides" the row by only changing the font color, not removing the rows. VBA coding is the only way to physically hide rows based on a cell value? Is there another option because I can't use macros. Thanks
Same here - looking to expand or hide based on if the row is blank but my clients will not see, use, or understand the VBA options (and therefore not be able to adjust them as needed later) - @@stevengergi6781
Hi. This is great and it works. Only issue is that it's causing the User Defined Type not Defined error if I type anything anywhere else in the workbook. This is frustrating. Can you help?
Hi, when using the VBA method, Iets say I set it to be USA, Then Canada, but then I want to delete that to be blank and hide both Canada, and USAC while the cell is blank, how would I do that ?
Can you show how to go down multiple levels? Using this example say I wanted to sort USA vs. Canada but then going down a level further say I wanted to sort between States inside of USA or Canada. So if I had another cell picking a state and then it showing the specific state row underneath USA or the specific state row under Canada based on the original selection?
Can I have the "USA" or "Canada" date entry cell be on a different sheet/tab or does it have to be on the same sheet/tab that the rows are being hidden on?
Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile.
Free Download link: bit.ly/3vBtYTA
Works really well
Thanks a million
What if you wanted to do this for more than one set of rows? For example, hide row 2 based on cell A1 AND hide row 5 based on cell A4 etcetera.
Thanks. Very simple way to get the job done.
You're Most welcome. Please Subscribe and Be with Us.
Hi, great tutorial. Just a question though (I'm very new to this and basically have zero knowledge), what if I want to run this a hundred times, lets say every after 20 rows. How will I do that? Thanks
Conditional formatting "hides" the row by only changing the font color, not removing the rows.
VBA coding is the only way to physically hide rows based on a cell value?
Is there another option because I can't use macros. Thanks
Did you figure it out? Have the same Issue
Same here - looking to expand or hide based on if the row is blank but my clients will not see, use, or understand the VBA options (and therefore not be able to adjust them as needed later) - @@stevengergi6781
Hi. This is great and it works. Only issue is that it's causing the User Defined Type not Defined error if I type anything anywhere else in the workbook. This is frustrating. Can you help?
Send me the workbook. It shouldn't have any error.
Hi, when using the VBA method, Iets say I set it to be USA, Then Canada, but then I want to delete that to be blank and hide both Canada, and USAC while the cell is blank, how would I do that ?
Can you show how to go down multiple levels? Using this example say I wanted to sort USA vs. Canada but then going down a level further say I wanted to sort between States inside of USA or Canada. So if I had another cell picking a state and then it showing the specific state row underneath USA or the specific state row under Canada based on the original selection?
Can I have the "USA" or "Canada" date entry cell be on a different sheet/tab or does it have to be on the same sheet/tab that the rows are being hidden on?
thank you so much, you explained it so well, not many people explains the saving part.
Thanks a million for your subscription and comment.
Thanks for nice video
Most welcome
Hi, I get "Run-time error '424': Object required" when using macro formula. Any suggestion ?
Same problem here
this just hides the font as a different colour though
Why this does not work for me
Try again. It should work
your not hiding the row, you just changing the color of the font and background, hiding the row means hiding the row number on the side of the sheets
Check the seond procedure