Rowan Drummond

Posts: n/a

need a conditional formula to generate numbers divisible by 4between a given starting no. & end No.

You're welcome.

Maybe you should add the line of code:
Application.Calculation = xlCalculationAutomatic
at the end of your macro.

Regards
Rowan

ramana wrote:
Thankyou Rowan, Its now working, the calculation setting was in manual
because there is macro in my workbook, where it says
application.calculation = manual, so when ever I runthe marcro it is
going to manual mode. Now my problem is solved.

Thanks and Regards

Ramana

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formula - language needed	gamebird	Excel Worksheet Functions	7	October 10th 05 11:48 PM
conditional formatting based on another cells formula result	kstarkey	Excel Discussion (Misc queries)	3	October 5th 05 09:07 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM
generate consecutive numbers	Mark	New Users to Excel	6	March 15th 05 06:45 PM

All times are GMT +1. The time now is 05:05 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us