Hi there,
I have searched high and low on this forum and have come across some a code which allows me to hide a range of rows, but unfortunately it only hides the rows and/or columns you label in the macro.
I have attached an example for those who may be able to assist.
My goal is to be able to insert new rows and have the macro self-correct itself to then see an additional row, if I add a row to the example which I have done on sheet two, it will then only hide the first 4 rows and leave the 5th row showing, whereas I want it to be hidden also.
Am I able to create a macro which would hide/unhide all rows which contain the data "123456", "55555", so that if I add a row between say rows 3 & 6 like in the example, it would automatically calculate this and when I run the macro it will hide all rows containing that data.
I would like to keep the function the same as when the box is ticked it shows the cells and when unticked, it hides the cells containing "123456", etc..
Hopefully I haven't confused anyone in my explanation.
Many thanks in advance.
James Tann
Bookmarks