Re: $$Excel-Macros$$ reduce the size of code

Sub > > Paul > > > > > From: Rajesh K R > To: excel-macros@googlegroups.com > Sent: Mon, February 14, 2011 9:29:32 AM > Subject: Re: $$Excel-Macros$$ reduce the size of code > > Hi Paul, > Thank you very much for your quick rep

Re: $$Excel-Macros$$ reduce the size of code

esh K R To: excel-macros@googlegroups.com Sent: Mon, February 14, 2011 9:29:32 AM Subject: Re: $$Excel-Macros$$ reduce the size of code Hi Paul, Thank you very much for your quick replies .Due to my lack of knowledge in vba I can't understand the code well .So I am attaching a project what I

Re: $$Excel-Macros$$ reduce the size of code

I'm not sure what your Import_fromregister macro is doing, so I'm not sure whether the sheet name needs to be a public variable. But this should loop through the months: Sub Update_sheets_All()     Dim M, ShtName     For M = 1 To 12     ShtName = Format(M & "/1/2011", "")     If Shee