Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
how to perform macro on each sheet in workbook.
(except first worksheet = "master data") I've tried the subs below but only worked on one sheet. Public Sub DoToAll() Dim ws As Worksheet For Each ws In Worksheets Application.Run "filldown" Next End Sub Sub loopthroughanddo() x = Sheets("master data").Index For Each sh In ThisWorkbook.Sheets If sh.Index x Then Application.Run "filldown" End If Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help needed: Getting all sheet setup data from one workbook toanother workbook | Excel Programming | |||
Copy rows from multiple workbook into a different workbook (sheet) | Excel Programming | |||
Copying data from workbook/sheets to another workbook/sheet | Excel Programming | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions |