Can anybody help pls. its really very imp for me
>________________________________ > From: dguillett1 <dguille...@gmail.com> >To: excel-macros@googlegroups.com >Sent: Friday, 10 February 2012 11:27 PM >Subject: Re: $$Excel-Macros$$ Replacement for Application.CalculateFull > > >try > >Application.Calculation = xlManual >sheets.select >for i=1 to sheets.count >activesheet.calculate >next i > > > >Don Guillett >SalesAid Software >dguille...@gmail.com >From: hanumant shinde >Sent: Friday, February 10, 2012 11:08 AM >To: Excel Group >Subject: $$Excel-Macros$$ Replacement for Application.CalculateFull > Hi, > >Can you please give any code or anything which will replace Application.CalculateFull. >when i use above code this calculates all the Open workbooks whereas i want to calculate only the Activeworkbook. > >i have tried below code but its not reliable as it does not calculate EVERYTIME. > >Public Sub CalcActiveWBOnly() >Dim wrksht As Worksheet > Application.Calculation = xlManual > For Each wrksht In ThisWorkbook.Sheets > wrksht.Calculate > Debug.Print wrksht.Name > Next wrksht >End Sub > >There is UDF lets say "test" which should get calculated after above code is executed but it doesnt happen everytime though the above code gets executed everytime. > > >its very very urgent and very very IMP for me. please help me.-- >FORUM RULES (986+ members already BANNED for violation) > >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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. > >NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. > >------------------------------------------------------------------------------------------------------ >To post to this group, send email to excel-macros@googlegroups.com > -- >FORUM RULES (986+ members already BANNED for violation) > >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) Cross-promotion of, or links to, forums competitive to this forum in >signatures are prohibited. > >NOTE : Don't ever post personal or confidential data in a workbook. Forum >owners and members are not responsible for any loss. > >------------------------------------------------------------------------------------------------------ >To post to this group, send email to excel-macros@googlegroups.com > > > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
