Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
initialize an array to 0
this should be an easy question for the excel gurus out there...i have an array with size 100 and i want to initialize every value in the array to 0...is there an easy way to do this without running a for loop? -- kdp145 ------------------------------------------------------------------------ kdp145's Profile: http://www.excelforum.com/member.php...o&userid=29594 View this thread: http://www.excelforum.com/showthread...hreadid=521719 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
initialize an array to 0
try this
Redim a(100) ' initial declaration of the variable your code Rem Clear A array redim a(100) more code Best N10 "kdp145" wrote in message ... this should be an easy question for the excel gurus out there...i have an array with size 100 and i want to initialize every value in the array to 0...is there an easy way to do this without running a for loop? -- kdp145 ------------------------------------------------------------------------ kdp145's Profile: http://www.excelforum.com/member.php...o&userid=29594 View this thread: http://www.excelforum.com/showthread...hreadid=521719 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
initialize an array to 0
Use the Erase function. If the array is dynamically resized with
ReDim, you'll have to ReDim it. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "kdp145" wrote in message ... this should be an easy question for the excel gurus out there...i have an array with size 100 and i want to initialize every value in the array to 0...is there an easy way to do this without running a for loop? -- kdp145 ------------------------------------------------------------------------ kdp145's Profile: http://www.excelforum.com/member.php...o&userid=29594 View this thread: http://www.excelforum.com/showthread...hreadid=521719 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
initialize an array to 0
kdp145 wrote:
this should be an easy question for the excel gurus out there...i have an array with size 100 and i want to initialize every value in the array to 0...is there an easy way to do this without running a for loop? I don't know what you mean by "i have an array", but any of the following will result in an array initialized with zeroes: Dim arr(100) As Integer Dim arr(100) As Long Dim arr(100) As Double Alan Beban |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Initialize an array | Excel Programming | |||
initialize userform, using a sub | Excel Programming | |||
Initialize macro | Excel Programming | |||
Initialize variable | Excel Programming | |||
Initialize data in new row? | Excel Programming |