Macro that hide or unhide and not calculate or calculate

  • Thread starter Thread starter Jonsson
  • Start date Start date
J

Jonsson

Hi
I have a column thats calculate time-values from each row, Mond-Sunday.
Each row refers to a person. Sometimes I don´t want certain rows/names to
show.

I need a macro that hides/unhide selective rows and not calculate/calculate
the sum of time to the totalsum at the bottom of the sheet.

Regards

//Thomas
 
Look in help at Data=>Filter =>Autofilter. Us the Subtotal worksheet
function to get your time totals - it will not operate on rows hidden by the
filter.
 
Back
Top