| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macro Help
Hi,
Am Mon, 5 Aug 2013 21:38:44 +0100 schrieb lostgrave2001: i have tried to edit my code to ecxept "ActiveSheet.Cells(rwIndex, 1).Select" but when i try to change out " Worksheets("Local" you want to run the code on all sheets? Then try: dim wsh as worksheet Application.ScreenUpdating = False For Each wsh In ActiveWorkbook.Worksheets your code next wsh And change into the code every "Worksheets("local")" and every "ActiveSheet" to wsh Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro to copy and paste values (columns)I have a macro file built | Excel Programming | |||
| Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor | Excel Programming | |||
| Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Threaded Mode
