LinkBack URL
About LinkBacks
On several worksheets column h has a numerical value. If the numerical value is 0 I would like the row to be automatically hidden. Can you suggest the code to place in the VBA module on each of the worksheets I want this functionality?
On several worksheets column h has a numerical value. If the numerical value is 0 I would like the row to be automatically hidden. Can you suggest the code to place in the VBA module on each of the worksheets I want this functionality?
Hello KEM4321,
Welcome to the Forum!
I think the last time I visited Kings Mountain, I was a teenager. Beautiful place.
Copy and paste this code in the ThisWorkbook module. This will hide any row when the value of cell in column "H" is zero. This will not hide a row if the value of cell in column "H" is the result of a formula, only if the user changes it manually.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks