Macro code to hide rows and not calculate hidden rows

B

bradmcq

Hi

I have a large spreadsheet that self populates from another sheet dependant
on certain criteria in the master sheet.

I want to hide rows based on the absence of a particular criteria, but I
want to hide them so that user can still use the auto filter without the
hidden rows re appearing.

I would also like the hidden rows to reappear if the criteria becomes
present inthe row due to changes inthe master sheet?

Currently due to the large number of rows and complex calculations inthe
sheets I need to have calculation set to manual. this will create some
problems for my novice users, so I was wondering if it is possible to write a
code that will not calculate the hidden rows, which will reduce the number of
rows to calculate in my array formulas, and mean i can then have calculations
set to auto. I would also like to be able to turn on calcuations fo rth
ehidden rows when needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hidden rows and autofill troubles 0
restore rows hidden in excel 2003 when using excel 2007 0
Macro to hide rows with zero values in columns 2
How do I print with hidden rows without gaps? 1
Macro to hide rows with zero in specifc column range 2
Enabling option „Format rows“ to hide/unhide rows using VBA-code? 0
Chart - size change with hide rows 1
Expand and Shrink Rows and columns to hide information. 1

Top