Hi All,
Im trying to create a macro to hide rows that are empty based on the visible coulmns only. The hidden columns however may contain data.

So if columns b,c & d were hidden and had data, e,f & g were visible and empty I would like to hide that row.

Thanks in advance.
Rob