| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help: Macro to to sum across selected visible worksheets
Hi there!
Can anybody help me design a macro that would sum across VISIBLE worksheets, that starts from, say 3rd worksheet up to the last visible one? thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to to sum across selected visible worksheets
You can test visible sheets for the .Visible property = xlSheetVisible.
Is this enough to get you going or do you need more? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "maimai" wrote in message om... Hi there! Can anybody help me design a macro that would sum across VISIBLE worksheets, that starts from, say 3rd worksheet up to the last visible one? thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to copy & paste-special-values data to selected worksheets | Excel Discussion (Misc queries) | |||
| Macro to work only on selected worksheets | Excel Discussion (Misc queries) | |||
| Run A Macro On Selected Worksheets | Excel Worksheet Functions | |||
| Modify a Macro to Repeat for all Selected Worksheets | Excel Worksheet Functions | |||
| Running a macro for all visible worksheets in a workbook | Excel Discussion (Misc queries) | |||
Linear Mode
