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
|