Posted to microsoft.public.excel.misc

Jeff

external usenet poster

Posts: 921

Overflow error when declaring variables

Hi,

When I declare the variable I get an overflow error -
depending on how it is declared.

Public IFundTable()

then in
Sub Macro1()
Redim IFundTable(1 to 5, 1 to 158510) 'There is no overflow error
Redim IFundTable(1 to 5, 1 to Count*10) 'Count = 15851, there is an error

Why?

Thanks for your help

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
Declaring variables in Module vs. Public	Jeff	Excel Discussion (Misc queries)	5	November 19th 07 08:27 PM
Overflow error.. why?	Fingerjob	Excel Discussion (Misc queries)	4	November 13th 06 05:18 PM
Declaring variables	freekrill	Excel Discussion (Misc queries)	2	July 19th 06 06:36 AM
Declaring variables	freekrill	Excel Discussion (Misc queries)	0	July 18th 06 06:15 PM
Overflow Error	DG	Excel Discussion (Misc queries)	3	April 15th 05 05:45 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us