Sometimes we hide certain rows or columns because we don't want the data to print, or just to get it out of the way. Other times though we simply don't want to share the data in a hidden row or column. Assuming that the data in visible cells isn't dependent on the data in hidden cells (i.e. if a formula references a hidden cell), we can use the macro below to automatically … [Read more...]