Macro that hide or unhide and not calculate or calculate

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
 
T

Tom Ogilvy

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.
 

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

HIDE-UNHIDE VBA MACRO 1
Can you hide and unhide rows with a macro based on content of colu 4
Hide and/or Unhide Worksheets 5
Can't hide/unhide rows under worksheet change event? 6
How to determine the worksheet that a calculate event gets initiated on when the workbook is not act 3
Macro to hide or unhide columns 1
hide rows with macro/togglebutton 22
Hide/Unhide Macro bug 1

Top