How can you take values stored in excel and store it in an array in VBA?

0 ⤊

How can you take values stored in excel and store it in an array in VBA?

example, create an array which stores the grades of 2 classes, one column per class, 30 students per class. one class is on sheet1 the other on sheet2 need the answer in about 14 hours.

2007-05-14 01:15:12 · 2 answers · asked by jaw 2 in Computers & Internet ➔ Programming & Design

2 answers

Use a paramArray in your function signature.

See my blog posting at: http://www.squidoo.com/thedataanalyst

Look for the posting: Convert Meters to Feet in Excel

The function signature includes a paramArray example.

The Data Analyst

2007-05-14 01:31:47 · answer #1 · answered by a_non_a_miss_2000 3 · 0⤊ 0⤋

What is VBA?

2007-05-14 08:18:11 · answer #2 · answered by hottotrot1_usa 7 · 0⤊ 1⤋