i'm new to Excel Macros and i'm trying to find a way in macros to auto hide rows whenever the content of the row is empty and to auto unhide when there are filled, the content of the rows depend on another worksheet, i'm using the IF function to determine whether the rows will be empty or will have content in them,
so any help would be usefull