nice tutorial.... very informative... it is very useful in making my reports. thanks a lot..
@ivairferrari
11 жыл бұрын
Very good! Congratulations! Teacher Ivair Ferrari ExcelMax Soluções
@adminbrod3440
4 жыл бұрын
Show error: variable not defined.. It's not working
@zakavision
11 жыл бұрын
thanks alot... it is very useful for my reports
@ModelbaanTBM
11 жыл бұрын
It is still possible to compress the 'HideBlanks()'-macro, namely as follows: Sub HideBlanks() Dim rng As Range For Each rng In Range("CheckRange") rng.EntireRow.Hidden = (rng = Empty) Next End Sub
@ModelbaanTBM
11 жыл бұрын
It's actually not necessary to put procedures in a module, they also work when you put them in a 'sheet-module'.
@tomshields7663
10 жыл бұрын
Hi Bill. Can you provide a link from your video files for the following: I am trying to hide rows if it has a zero value within a column only when printing. I need to allow all the descriptions in each row to remain while the user is placing values. The only rows I want to appear are when the value is greater than zero. Each file when then be saved with its own bid number however the form will remain the same each time the template is opened. They may add rows from time to time. Thank you. Sincerely.
@naomidommisse2054
10 жыл бұрын
Is there a way to hide a row of borders if empty without using pivit table? I have to set something up for my parents who only can type some value's without hitting the reapply button ;) macro expression would also be fine
@aaronmorrisey2265
8 жыл бұрын
I need a simple macro or some kind of solution that will hide rows when a cell from a drop downs value "Yes" and will unhide when the value is "No" Any help would be great!
@carolinemead9911
9 жыл бұрын
I have done exactly what you say to do but instead of hiding rows im hiding columns. Its working BUT its hiding columns that have any row that is empty. I would like to only hide columns if the complete column is empty in my range. (one row could be populated and the rest empty. How do I do this please? I have tried to figure it out myself but failed :( Great tutorial btw :)
Пікірлер: 10