array handling

**newbsie** · 06-10-2015, 03:30 PM

Hello,

I am looking for a better way to handle my arrays. I do an import of a sheet with 9601 rows and 20 columns. The number of rows is flexible, so sometimes its 9600 + header-row and sometimes its just 4800 + header-row.

So at first I count the number of rows (var RowLast) and divide by 96 (because each BL has 96 quarterhours).

This is my vba, which is working (any advice ?) :

Please Login or Register  to view this content.

In my first column are strings(names), which are changing each 96rows.
Instead of BLNames(i) I would like to use "String(2,1)". Is this possible ?

Example:
row 1 to 96, column 1: Audi A1
row 97 to 192, column 1: Audi A3
row 193 to 288, column 1: Audi A7

MsgBox(Audi A1(2,1))
MsgBox(Audi A3(2,1))
MsgBox(Audi A7(2,1))

Thanks in advance

**Richard Buttrey** · 06-10-2015, 04:21 PM

Hi,

Why do you need VBA?
It's highly probable that simple Excel functions can give you what you want. Upload the workbook and manually add the results you expect and tell us which are the result cells and if it's not obvious the logic you have used to arrive at the results.

**newbsie** · 06-10-2015, 05:37 PM

Hi Richard,

well, this is just one step of my VBA and I was looking for a better way to handle this arrays. I need to calculate some stuff based on the 20 columns. Also there is a strategy and logic, which needs to be integrated into my workbook. So I reckon its the best way to write all this stuff in VBA. I dont want to have a mix between in-sheet-calculations and vba. I also work with an matlab integration.

Do you have any idea for a better array handling based on names (strings)?