hello everyone. i am looking for a loop for work sheets in a workbook.
i have a workbook ,rte1, that has 5 worksheets in it that are called tue,wed,thu,fri,sat. how can i make a macro that will perform a task on the first worksheet and then perform it on the next and so on. i have a macro now that does this but i access each sheet with its own code, which is the same, so the code is really long and redundant
i have a workbook ,rte1, that has 5 worksheets in it that are called tue,wed,thu,fri,sat. how can i make a macro that will perform a task on the first worksheet and then perform it on the next and so on. i have a macro now that does this but i access each sheet with its own code, which is the same, so the code is really long and redundant