spreadsheet into excel
spreadsheet into excel
(OP)
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





RE: spreadsheet into excel
In the VBE, you can now reference any element of that range using the syntax
Range("MyRange")(RowNumber,ColumnNumber)
You can establish the size of the Range with
Range("MyRange").Rows.Count
and
Range("MyRange").Columns.Count
That should be enough to get you started.