How to declare an array/range with variable with Excel

I'm making a grade book program using excel, so the number of students change as well as assignments and I don't know how to get VB to accept arrays or ranges that are declared with variables

here's a tutorial project show how to create / read from / write to excel using VB

I assume your spreadsheet contains the student names and assignment/test grades. Also, if you are a teacher, you probably have more than one class. It would help to know how your Excel file is structured. If it were me, I'd have a separate sheet for each class, student names down the rows, assignments across the columns like a regular grade book (although transposing the names/assignments wouldn't be a problem).

Either way, you could use dynamic arrays to read/write to the Sheet. If you can provide additional information as to what you'd like to do, I can give you some sample code.

Nate