Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cycle through worksheets and sum
I want to write some VBA to cycle through all worksheets in a workbook and
copies the value 4 cells across from the one that contains "Total" into Row B of my totals workshets, and also the value in cell D10. Ideas? Thanks Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cycle through worksheets and sum
To loop through all the worksheets
For Each sh In Activeworkbook.Worksheets .... Next sh To find "Total", look at the Find method in VBA help. To offset by 4 cells, use Offset(0,4) The value in D10 can be addressed directly Range("D10").Value -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "David M C" wrote in message ... I want to write some VBA to cycle through all worksheets in a workbook and copies the value 4 cells across from the one that contains "Total" into Row B of my totals workshets, and also the value in cell D10. Ideas? Thanks Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut key to cycle through worksheets in the same workbook | Excel Discussion (Misc queries) | |||
How do I cycle through all of the worksheets | Excel Discussion (Misc queries) | |||
How do I cycle through all of the open worksheets? | Excel Discussion (Misc queries) | |||
Cycle through all worksheets | Excel Programming | |||
Cycle thru worksheets in a workbook | Excel Programming |