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

2011-02-14 Thread Paul Schreiner
End Sub Paul From: Rajesh Kainikkara rajeshkainikk...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Sun, February 13, 2011 11:17:50 AM Subject: $$Excel-Macros$$ reduce the size of code Hi I have a workbook which contain 15 sheets

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

2011-02-14 Thread Paul Schreiner
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 am supposed to make which have the same problem. please check the attached file and make

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

2011-02-14 Thread Rajesh K R
: $$Excel-Macros$$ reduce the size of code Hi I have a workbook which contain 15 sheets ,sheet1 is the data of January, sheet2 is February and so on, the last 3 sheet have some data for comparison.I am using a macro code to copy the data like this Sub Update_sheet_April()     If Sheets(APRIL

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

2011-02-13 Thread Rajesh Kainikkara
Hi I have a workbook which contain 15 sheets ,sheet1 is the data of January, sheet2 is February and so on, the last 3 sheet have some data for comparison.I am using a macro code to copy the data like this Sub Update_sheet_April() If Sheets(APRIL).Range(b5) = 0 Then