Posted to microsoft.public.excel.programming

David Myle David Myle is offline

external usenet poster

Posts: 11

Overflow puzzle

Hi all,

My VBA editor returns a Run time overflow error for 300*8520000
but calculates without any fuss
2556*10^6
Yet both figures are the same viz: 2556000000
The same editor has no problem evaluating 2556*10^300

What gives?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
vlookup puzzle	lloyd	Excel Worksheet Functions	3	December 6th 07 07:45 PM
VLOOKUP puzzle ??	Anthony	Excel Worksheet Functions	8	November 29th 06 05:49 PM
Can you help!!!!! New Puzzle	Krefty	Excel Discussion (Misc queries)	0	June 13th 05 08:13 PM
VBA overflow	Tom Ogilvy	Excel Programming	3	September 2nd 03 09:04 PM
VBA overflow	Don Guillett[_4_]	Excel Programming	2	September 2nd 03 04:19 PM

All times are GMT +1. The time now is 06:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us