appreciate the tutorial go it working, but how to unhide the rows after clicking the button, i thought by clicking it again would do it, but did not, do i need another macro if i want the hidden cells to show
yes, you'd need to have another macro for that.. i believe I mentioned in the video to just create another button, and then just use the record macro button and proceed with unhiding all the rows by highlighting all cells (CTRL A). that would immediately create a macro code for your unhiding of rows.
as mentioned in the tutorial, you can just use the record macro feature of excel; select all cells (CTRL + A) right click on any row, and choose unhide. The code will automatically be written for you to inverse the function of this tutorial
Hi, Thank you for sharing this tutorial... A question, how to hide a row based on values in different cells of different columns... e.g I want row #2 to automatically hide if cell B2 cell value is "O" or if cell C2 cell value is "P" or if cell D2 cell value is "Q" ...
you can use a conditional argument in your helper column with an OR syntax: =OR(B2="O",C2="P",D2="Q"), the return value of this conditional argument may be true or false which can be assigned with "1" or "0" in the vba reference.
I dont know when was this made... but he made a simple task complicated. Just do this: Select the whole range you want Filtered. Go to DATA>Filter... or press Ctrl+Shift+L Then filter according to your needs.... no formulas needed
Yes, that may be true. The purpose of the video is to show everyone how to use the VBA codes we are utilizing in the different automated templates we created. This option is universal which does not rely on the restrictions of DATA FILTER option on merged cells. As demonstrated, we are referencing the cells based on their actual cell name which can be extended in a multiple array of applications. With this method, an approach on referencing towards merged cells may not be a problem. Further, this option also allows the user to use buttons which can be activate the VBA with just 1-click instead of multiple clicks in a Filter Option.
Error 424 in Excel VBA is a runtime error that occurs when the program tries to reference an object that doesn't exist or is not recognized by the system. The error message "Object Required" is shown when the program tries to use an object variable that has not been set or initialized.
Hello my friend, thank you for the tutorial it was very helpful. is it possible to tell me how i can do this button to Hide and Unhide the rows ? with your commands i can hide them but i can not unhide the hidden rows
I'm not sure if I mentioned it in the video but to unhide these rows would relatively be easy just by using the record macro button. you basically hit the record macro button, highlight all the rows (both hidden and unhidden rows), right click the row numbers, choose the show all rows (unhide it) and stop the recording. Excel will pretty much make the VBA for you. Just assign that code to a new button and you're good to go.
it doesn't. And I believe I already mentioned that in the video's latter part. Unhiding the rows would require another button and you can just use the macro record option to select all cells and then unhide rows.
When i closed my excel file and reopened it my macro script disappeared and the button no longer worked even though i saved the file before closing, any clues ?
You do a good job but spend too much time off subject. I am now at 9 minutes of the 13 in the video and you still have not told me how to auto-hide the rows. Instead, you spent well over half of the video teaching other things.....come on man! And, what's up with the annoying background music bro?
hey man, appreciate the comment.... you know most of my tutorials are for beginner excel users and hoping that by showing it step-by-step, they won't have any issues when running the process in their own. as for the music,lol, sorry man, i like that background music man... it kinda' keeps me up.. but sorry if you found that annoying.
yes, that would have been easier but the values were not treated as integers but as text and the formula was presented in order for the viewers to understand that the values 1 and 0 can also be "yes" or "no"; or "true" or "false"; whichever they would prefer. In such a case, the multiplication formula would not work.
"Runtime Error 1004" is a common error that occurs when a macro or VBA code tries to access a worksheet or range that does not exist, or when the user does not have permission to perform the requested operation. Here are some possible causes and solutions for "Runtime Error 1004": Invalid range or worksheet name: If the code tries to access a range or worksheet that does not exist or has an invalid name, it will result in a 1004 error. Make sure that the range or worksheet name is spelled correctly and exists in the workbook. Locked cells or protected worksheet: If the code tries to modify a locked cell or a protected worksheet, it will cause a 1004 error. You can unlock the cells or unprotect the worksheet before running the code, or modify the code to work with the protected worksheet.
Actually I’ve re-watched the video and it’s not that bad, however, the video is a bit too long and people will loose concentration. The first 6 minutes was good but the last few minutes could have been simpler and more straightforward perhaps. In anycase I’ve given you thumbs up 👍🏾
Brilliant work
thanks
Pretty good, it also hid the female row as well.
the function will read the data based on the helper columns which were created :)
appreciate the tutorial go it working, but how to unhide the rows after clicking the button, i thought by clicking it again would do it, but did not, do i need another macro if i want the hidden cells to show
yes, you'd need to have another macro for that.. i believe I mentioned in the video to just create another button, and then just use the record macro button and proceed with unhiding all the rows by highlighting all cells (CTRL A). that would immediately create a macro code for your unhiding of rows.
I really learned from this tutorial. What will the code if I will unhide the hidden rows? I am hoping much of your reply. Thank you so much
as mentioned in the tutorial, you can just use the record macro feature of excel; select all cells (CTRL + A) right click on any row, and choose unhide. The code will automatically be written for you to inverse the function of this tutorial
Hi, Thank you for sharing this tutorial...
A question, how to hide a row based on values in different cells of different columns...
e.g I want row #2 to automatically hide if cell B2 cell value is "O" or if cell C2 cell value is "P" or if cell D2 cell value is "Q" ...
you can use a conditional argument in your helper column with an OR syntax:
=OR(B2="O",C2="P",D2="Q"), the return value of this conditional argument may be true or false which can be assigned with "1" or "0" in the vba reference.
Nice content sir
thanks sir!
I dont know when was this made... but he made a simple task complicated.
Just do this:
Select the whole range you want Filtered.
Go to DATA>Filter... or press Ctrl+Shift+L
Then filter according to your needs.... no formulas needed
Yes, that may be true. The purpose of the video is to show everyone how to use the VBA codes we are utilizing in the different automated templates we created. This option is universal which does not rely on the restrictions of DATA FILTER option on merged cells. As demonstrated, we are referencing the cells based on their actual cell name which can be extended in a multiple array of applications. With this method, an approach on referencing towards merged cells may not be a problem. Further, this option also allows the user to use buttons which can be activate the VBA with just 1-click instead of multiple clicks in a Filter Option.
Thank you random commenter on RUclips!
What is error 424 and its showing object required
Error 424 in Excel VBA is a runtime error that occurs when the program tries to reference an object that doesn't exist or is not recognized by the system. The error message "Object Required" is shown when the program tries to use an object variable that has not been set or initialized.
Hello my friend, thank you for the tutorial it was very helpful. is it possible to tell me how i can do this button to Hide and Unhide the rows ? with your commands i can hide them but i can not unhide the hidden rows
I'm not sure if I mentioned it in the video but to unhide these rows would relatively be easy just by using the record macro button. you basically hit the record macro button, highlight all the rows (both hidden and unhidden rows), right click the row numbers, choose the show all rows (unhide it) and stop the recording. Excel will pretty much make the VBA for you. Just assign that code to a new button and you're good to go.
@@IntegratedSchoolForms that's an ingenious way, thanks :)
@@harrylew8064 great to help
ok this doesnt unhide though does ? once i push the button, pressing it again does not unhide ??
it doesn't. And I believe I already mentioned that in the video's latter part. Unhiding the rows would require another button and you can just use the macro record option to select all cells and then unhide rows.
When i closed my excel file and reopened it my macro script disappeared and the button no longer worked even though i saved the file before closing, any clues ?
You should save the your excel file as .xlsm or .xlsb to keep the macro working even when you close it.
What if you want to show it again? or need to unhide manually? thanks sir
i believe we suggested that in the video using record macros
I have the same issue i don’t know what part are you talking about, i cannot show them again
Hello, How can I automatically hide rows based on a cell value without VBA codes? I can not use macros. Thanks
How come you can't use macros? There ain't any automated way to hide rows based on cell values, as far as I know.
You do a good job but spend too much time off subject. I am now at 9 minutes of the 13 in the video and you still have not told me how to auto-hide the rows. Instead, you spent well over half of the video teaching other things.....come on man! And, what's up with the annoying background music bro?
hey man, appreciate the comment.... you know most of my tutorials are for beginner excel users and hoping that by showing it step-by-step, they won't have any issues when running the process in their own.
as for the music,lol, sorry man, i like that background music man... it kinda' keeps me up.. but sorry if you found that annoying.
You could simply multiply column1 * Column 2 and the result would be Zero if any of the columns were Zero, no need to write the "or" formula.
yes, that would have been easier but the values were not treated as integers but as text and the formula was presented in order for the viewers to understand that the values 1 and 0 can also be "yes" or "no"; or "true" or "false"; whichever they would prefer. In such a case, the multiplication formula would not work.
Run-Time error 1004?
And on clicking button ×400?
"Runtime Error 1004" is a common error that occurs when a macro or VBA code tries to access a worksheet or range that does not exist, or when the user does not have permission to perform the requested operation.
Here are some possible causes and solutions for "Runtime Error 1004":
Invalid range or worksheet name: If the code tries to access a range or worksheet that does not exist or has an invalid name, it will result in a 1004 error. Make sure that the range or worksheet name is spelled correctly and exists in the workbook.
Locked cells or protected worksheet: If the code tries to modify a locked cell or a protected worksheet, it will cause a 1004 error. You can unlock the cells or unprotect the worksheet before running the code, or modify the code to work with the protected worksheet.
What causes Run Time Error 400?
you can check the specific line in the macro window that might cause this error. there are many possible causes. better double check the codes too.
@@IntegratedSchoolForms Done it...thank you.... can you very much sir...
@@tindencen great to help
Very poor explanation 😢
Which part?
Actually I’ve re-watched the video and it’s not that bad, however, the video is a bit too long and people will loose concentration. The first 6 minutes was good but the last few minutes could have been simpler and more straightforward perhaps. In anycase I’ve given you thumbs up 👍🏾
@@aajayi If you are going to comment, you better be 100% yourself - like your spelling - Loose ?
@@iainhmunro no idea what ur talking about 🤔