Macro that hide or unhide and not calculate or calculate
 

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

Macro that hide or unhide and not calculate or calculate
 

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.

--
Regards,
Tom Ogilvy


"Jonsson" wrote in message
...
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