RE: $$Excel-Macros$$ not able to repeat code through all sheets in workbook

2015-08-18 Thread gargee singh
n and help me improve the code. It works wonderfully now. :) :) Thanks and Regards, Gargee Singh Date: Tue, 18 Aug 2015 12:14:58 + From: schreiner_p...@att.net To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ not able to repeat code through all sheets in workbook "T

Re: $$Excel-Macros$$ not able to repeat code through all sheets in workbook

2015-08-18 Thread Paul Schreiner
once we run the code I want it to run on all sheets and move databased on the month mentioned in E1 .   Thanks and Regards, Gargee Singh   Date: Mon, 17 Aug 2015 11:44:25 + From: schreiner_p...@att.net To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ not able to repeat code t

Re: $$Excel-Macros$$ not able to repeat code through all sheets in workbook

2015-08-17 Thread Paul Schreiner
Are you saying that you want the macro to repeat for all sheets? If so, you need to set up a loop to process all sheets. Using your macro, you can create a separate macro like: Sub Process_All()   Dim Sht  for each Sht in Sheets    if ((sht.name <> "Summary A") _    and (sht.name <> "Summary B") _