Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
macro sheet name conflicts
I have a hundred workbooks, each with ten sheets. The sheets are identical in
structure and I want to create a macro that will run on each sheet of each workbook. The problem comes with the fact that the worksheets aren't consistently named across workbooks and so any sheet name references won't work. My work around has been to write a general macro that will run on one sheet and then select the sheets one by one and run it on each. I open each workbook and run it sheet by sheet, which is time consuming. I'm wondering if it's at all possible to create a macro that will run on all sheets in a workbook regardless of their names. Thanks for any help. spence |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save conflicts | Excel Discussion (Misc queries) | |||
Sheet protection code conflicts with Pivot Table "auto refresh" | Excel Discussion (Misc queries) | |||
Excel Option Conflicts | Excel Discussion (Misc queries) | |||
Excel Option Conflicts | Excel Discussion (Misc queries) |