Hi Girish,
I was just going through your attached VBA code. I have observed that in
many places your VBA code is using excel formulas. As per my experience the
more you will use excel formula in your spreadsheet it will slow the
performance of your spreadsheet. You can turn the automatic calculation
feature off by the following code :
Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
End Sub
Hope this will help you.
Regards,
Deepak Rai
On Thu, Nov 25, 2010 at 6:45 PM, girish kumar
<girishkumar832...@gmail.com>wrote:
> Dear Experts,
>
> I have attached one VBA Code which we are using regularly
> for huge data it is running very slow
>
> is there any way to make it faster
>
> Pls Suggest
>
> Thanks in advance
>
> Girish
>
>
> --
> Warm Regards,
>
> *Girish Sherigar*
>
> *(¨`·.·´¨) *
> *`·.¸(¨`·.·´¨)* *Keep*
> *(¨`·.·´¨)¸.·´ Smiling!*
> *`·.¸.·´*
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
--
Regards,
Deepak Rai
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
