Re: Array limit
From: Ken Wright (ken.wright_at_NOSPAMntlworld.com)
Date: 03/09/04
- Next message: Tom Ogilvy: "Re: Data Validation in VBA"
- Previous message: Todd: "Re: Deleting rows based on cell is empty"
- In reply to: Ken Wright: "Re: Array limit"
- Next in thread: Tom Ogilvy: "Re: Array limit"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 9 Mar 2004 20:07:37 -0000
Oops - I was in a formula frame of mind, not VBA - Sorry :-(
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
news:uYKKmFhBEHA.3360@TK2MSFTNGP11.phx.gbl...
> Only possibly in terms of speed, ie it may slow you down a bit - depends on
lots
> of factors. Main limit is that you cannot have more than 65,535 cells in a
> single dimension, so cannot use whole column references, though it is
porobably
> better to look at a dynamic range anyway which will be smaller and possibly
more
> efficient.
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
>
>
> "Mike" <anonymous@discussions.microsoft.com> wrote in message
> news:9fac01c4060f$7f984c20$a101280a@phx.gbl...
> > Is there any limit on the number of items that can be
> > loaded into an array?
> >
> > I'm looking at creating an array that has 2,500 - 3,000
> > records with 5 fields in each record? Will this cause me
> > any problems later in the macro?
> >
> > Thanks
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.613 / Virus Database: 392 - Release Date: 04/03/2004
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.613 / Virus Database: 392 - Release Date: 04/03/2004
- Next message: Tom Ogilvy: "Re: Data Validation in VBA"
- Previous message: Todd: "Re: Deleting rows based on cell is empty"
- In reply to: Ken Wright: "Re: Array limit"
- Next in thread: Tom Ogilvy: "Re: Array limit"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
