Calculate Macro

Gaurav Karira

Board Regular
Joined
Jun 13, 2003
Messages
121
Hio Guys

this should not tough for u experts out there...

I have a very huge file.......14MB..... has loads of formulassss Vlookups in tons........ and on top of it , this would be used by many people...

what help I m looking for ......

I need a Vba/ Macro which would do a detail calculation something like CTRL+ALT+F9....... thro all the worksheets.......

I mean I would give a button which when user presses the the calculation wd be done thro out the workbook......

Also if someone can add a status bar in macro in that macro with a message like "Please wait calculating data" that would just be gr8

I dont know If i m expecting toooo much but i guess this wont be much tough for u experts .....

I have my work books on manual calculation and want to keep them manual only as otherwise my excel wd crash....

Thx
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Mr Walker

Board Regular
Joined
Jan 21, 2003
Messages
131
Try putting this in the code behind your button.

Code:
Application.CalculateFull


Should work in 2000, don't know about 97.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,159
Messages
5,768,520
Members
425,479
Latest member
Neerajcool

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top