Hi,
In attached file you can see one sheet.
I have two table and 6 buttons. With HRB (Hide Row Button) I want to hide empty rows or rows which different values but with empty "G" column. First HRB is functional, but I want to relate with another column ("H"). For example in this table I want to hide Excel rows: 6, 9-14, because calculation in G and H column are without value or zero. In VBA Module 1 are for rows.
Second problem is with column button. With HCB (Hide Column Button) I want to hide column from 9-12 ("I" - "L"). In this case I want to hide only "J" column and not to hide "L" column, because this column is not empty in second table.
Thanks in advance.
Bookmarks