Dear Pavan, The Macro is password protected.
Warm Regards, Gawli Anil On Wed, May 15, 2013 at 2:15 PM, Pavan Chowdary <pavansai.vall...@gmail.com>wrote: > Thanks for the reply. But it is highly restricted to share workbook as it > is part of my office work. I am attaching sample workbook for which i need > to copy share price formula for all those companies inputted in the file > which and for the dates given. please take a look. > > > On Wed, May 15, 2013 at 2:04 PM, अनिल नारायण गवली <gawlianil8...@gmail.com > > wrote: > >> Dear Pavansai, >> >> Share the workbook with us. >> >> Warm Regards, >> Gawli Anil. >> >> >> On Wed, May 15, 2013 at 1:57 PM, Pavan Valluru < >> pavansai.vall...@gmail.com> wrote: >> >>> Hi There, >>> >>> This is pavan. Im a Financial Modeler. I need VBA in My work. Now a days >>> i am getting models which will need macro to update huge data. Like I need >>> to copy single data point accross 10000 columns and 5000 rows. For this i >>> used below to perform this task. >>> >>> 1. No Array Formulas in the Workbook. >>> 2. Screen updating to false. >>> 3. I used Section Refresh Macro. i.e 50 rows per interation. >>> 4. I am setting excel calculation to manual and automatic as the case >>> may require. >>> 5. Pasting as Values. >>> >>> So otherthan this is there any suggestions for me to increase macro >>> performance and not to crash excel. >>> like Pausing macro for some time say Eg: 2 minutes. etc. I guess it will >>> release System RAM Memory. Please share your views on this. >>> >>> -Pavan >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >>> >> >> >> >> -- >> Thanks & Regards, >> Gawli Anil Narayan >> Software Developer, >> Abacus Software Services Pvt Ltd >> > > -- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
