auto hide unhide
 

Hi all,


Does anyone know a suitable piece of code that will allow
me complete the following...

I have a huge spreadsheet, however in one column I have a
list of formulae's, I would like a piece of code that if
the result of the formulae is zero then that row is hidden
and so continue like that all the way down the sheet...
hiding or not hiding.

they idea behind this is that the formula relates to a
separate workbook and as such may or may not contain a
result (non zero) dependant on the information updates
made else where.

Basically I would like the main workbook to only show
relevant rows and automatically hide and unhide rows with
actual information

Hope this makes a little sense,
Thanks for any help

Andy

auto hide unhide
 

I think I might use Data|Filter|autofilter.

If I needed a macro, I'd record one when I did it the first time.

Andy wrote:

Hi all,

Does anyone know a suitable piece of code that will allow
me complete the following...

I have a huge spreadsheet, however in one column I have a
list of formulae's, I would like a piece of code that if
the result of the formulae is zero then that row is hidden
and so continue like that all the way down the sheet...
hiding or not hiding.

they idea behind this is that the formula relates to a
separate workbook and as such may or may not contain a
result (non zero) dependant on the information updates
made else where.

Basically I would like the main workbook to only show
relevant rows and automatically hide and unhide rows with
actual information

Hope this makes a little sense,
Thanks for any help

Andy

--

Dave Peterson