| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to hide/unhide WS based upon WS tab color | Excel Discussion (Misc queries) | |||
| Macro code to hide rows and not calculate hidden rows | Excel Discussion (Misc queries) | |||
| Macro-Hide & Unhide Sheets with condition | Excel Discussion (Misc queries) | |||
| Macro that will unhide then hide rows | Excel Discussion (Misc queries) | |||
| hide/unhide macro | Excel Discussion (Misc queries) | |||
Linear Mode
