LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default how do i fill an array? tia

i know this is probably pretty basic but i can't find it in my dummies
book.

i have an array labeled M.
i've dimensioned it to 100 using the statement:

dim m(100)

i tried to run a for/next loop to fill it but it isn't working

for x = 1 to 100
m(x)=5
next x

this should fill array with 5's but it's giving me an error:
sub or function not defined.

thanks for your help
fred
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Fill in cells with an array dgh Excel Discussion (Misc queries) 0 May 15th 09 08:42 PM
fill array with only values GKeramidas Excel Programming 3 September 4th 06 09:57 AM
FILL ARRAY ONE ROW AT A TIME [email protected] Excel Programming 3 August 25th 06 09:52 PM
fill array [email protected][_2_] Excel Programming 7 March 20th 06 01:01 PM
fill down array to last available row [email protected] Excel Worksheet Functions 10 May 19th 05 10:52 PM


All times are GMT +1. The time now is 07:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"