Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to apply VBA code to multiple Worksheets
I have this code listed below which is in a macro module. Is there a way that I can apply this code to only the worksheet I am working in. I have worksheets labeled January thru December and need to distinqiush between the sheets. Dim rng As Range Dim lastrow As Long, r As Long, i As Integer With Worksheets("January") <<----This needs to be a variable for each sheet lastrow = .Cells(Rows.Count, "A").End(xlUp).Row r = 1 srow = r Do Do r = r + 1 Loop Until .Cells(r, "a") = "Weekly Subtotal" Or r = lastrow For i = 4 To 6 Set rng = .Range(.Cells(srow, i), .Cells(r - 1, i)) Cells(r, i) = Application.Sum(rng) Next i srow = r + 1 Loop Until srow lastrow End With -- parteegolfer ------------------------------------------------------------------------ parteegolfer's Profile: http://www.excelforum.com/member.php...o&userid=31951 View this thread: http://www.excelforum.com/showthread...hreadid=521533 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to apply VBA code to multiple Worksheets
Change
With Worksheets("January") to With Activesheet -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "parteegolfer" wrote in message news:parteegolfer.24knwy_1142192702.1115@excelforu m-nospam.com... I have this code listed below which is in a macro module. Is there a way that I can apply this code to only the worksheet I am working in. I have worksheets labeled January thru December and need to distinqiush between the sheets. Dim rng As Range Dim lastrow As Long, r As Long, i As Integer With Worksheets("January") <<----This needs to be a variable for each sheet lastrow = .Cells(Rows.Count, "A").End(xlUp).Row r = 1 srow = r Do Do r = r + 1 Loop Until .Cells(r, "a") = "Weekly Subtotal" Or r = lastrow For i = 4 To 6 Set rng = .Range(.Cells(srow, i), .Cells(r - 1, i)) Cells(r, i) = Application.Sum(rng) Next i srow = r + 1 Loop Until srow lastrow End With -- parteegolfer ------------------------------------------------------------------------ parteegolfer's Profile: http://www.excelforum.com/member.php...o&userid=31951 View this thread: http://www.excelforum.com/showthread...hreadid=521533 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to apply VBA code to multiple Worksheets
Thanks Bob this worked well! -- parteegolfer ------------------------------------------------------------------------ parteegolfer's Profile: http://www.excelforum.com/member.php...o&userid=31951 View this thread: http://www.excelforum.com/showthread...hreadid=521533 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to apply macro across multiple worksheets within a workbook | Excel Discussion (Misc queries) | |||
Apply code to other worksheets | Excel Programming | |||
Apply Macro on Multiple Worksheets in a Workbook | Excel Programming | |||
Apply Macro on Multiple Worksheets in a Workbook | Excel Programming | |||
Apply Macro on Multiple Worksheets in a Workbook | Excel Programming |