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 macro 19
Faster code to quickly hide several rows? 7
Macro for hiding/unhiding a set of rows 3
Macro to Unhide Rows 3
Unhide/hide based on drop down list 0
VB Code to hide rows 3
HIDE-UNHIDE VBA MACRO 1
Can you hide and unhide rows with a macro based on content of colu 4

Top