| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Applying Macro to only certain sheets
Howdie, My VB currently applies to all sheets in workbook. I only want it to apply to sheets A, D, E (Even if I hide sheets b and C) it sitll applies it to them Can I change the VB below to specify my required sheets as a range, and then refer to that range somehow...? VB extract: For Each sh In ActiveWorkbook.Worksheets If sh.Name < DestSh.Name Then Last = Lastrow(DestSh) sh.Range("b9:p20").Copy DestSh.Cells(Last + 1, "A") *** Sent via Developersdex http://www.developersdex.com *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| applying COUNTIF formula across several sheets | Excel Discussion (Misc queries) | |||
| applying formulas for all sheets selected | Excel Worksheet Functions | |||
| Applying J-Walk's SheetOffset() to SUM across sheets - possible? | Excel Worksheet Functions | |||
| Applying Protection To Multiple Sheets | New Users to Excel | |||
| applying rules to Excel Sheets using Macros | Excel Programming | |||
Threaded Mode
