spreadsheet into excel

[petert00]

I haven't worked with VBA for a while. I'm trying to write a code that reads a list of numbers from the spreadsheet and average those numbers at every three intervals. Could anyone give me an idea as to how to read the numbers into VBA thanks

 

[Denial]

In the worksheet, assign a "name" to the full extent of the list (Insert / Name / Define). Let that name be [tt]MyRange[/tt].

In the VBE, you can now reference any element of that range using the syntax
[tt]Range("MyRange")(RowNumber,ColumnNumber)[/tt]
You can establish the size of the Range with
[tt]Range("MyRange").Rows.Count[/tt]
and
[tt]Range("MyRange").Columns.Count[/tt]

That should be enough to get you started.