Calling Mark o brien!

[RET79]

Hi there.

If Mark o Brien is out there, would he be kind enough to help me finish off the 'tedious definitions' message in which he gave me some great advice a month or so ago.

http://www.mrexcel.com/board/viewtop...rum=2&start=10

Thanks!

[Mark O'Brien]

Of course I'm here.

Do you just need help with that last post you had on the other thread? (I was working in another State that week, hence the reason I didn't answer a couple of weeks ago)

[RET79]

Hi Mark!

Yes, I am not sure how now to assign the values to the new array we have defined, or how to put the new array onto the spreadsheet.

Before we had just arr1, arr2 etc. but now we have arr(1) arr(2) so it is quite confusing for me how to do it properly.

Thanks again,

RET79

[Mark O'Brien]

Damn, I was hoping you wouldn't be online right now.

What the hell are you doing up at 2.30am?

[Mark O'Brien]

Does this work ok?

  'This would do all of the Debug.Print statements

  For j = 3 To zm(i)

    Debug.Print rngMonth(i)(k, 1)

  Next

..taken from the code I suggested as an example.

[RET79]

Hehe, well I'm a bit nocturnal these days as I'm in the middle of exams so I sleep when I like and study when I like. hehe.

Don't worry, no rush with that thing.

RET79

[RET79]

Hi there.

If Mark o Brien or anyone else out there can help me finish off this problem then I would be most grateful.

It is this line which is causing me distress:

arrcells1(k - 1, cellx - 1) = Cells(rngcells1(cellx + 1, 2), rngcells1(cellx + 1, 3)).Offset(0, tl8 * (k - 1)).Value


rngcells1 and arrcells1 were defined the old way here. Now we have got rngcells(i) so logically speaking you are looking at setting up arrcells(i)(k-1,cellx-1) here but of course this does not work in VBA.

RET79

[RET79]

On 2002-05-02 10:08, RET79 wrote:
Hi there.

If Mark o Brien or anyone else out there can help me finish off this problem then I would be most grateful.

It is this line which is causing me distress:

arrcells1(k - 1, cellx - 1) = Cells(rngcells1(cellx + 1, 2), rngcells1(cellx + 1, 3)).Offset(0, tl8 * (k - 1)).Value


rngcells1 and arrcells1 were defined the old way here. Now we have got rngcells(i) so logically speaking you are looking at setting up arrcells(i)(k-1,cellx-1) here but of course this does not work in VBA.

RET79

For instance, I want this


arrcells(i)(k - 1, cellx - 1) = Cells(rngcells(i)(cellx + 1, 2), rngcells(i)(cellx + 1, 3)).Offset(0, tl8 * (k - 1)).Value


but this doesnt work for some reason, maybe arrcells is not defined correctly??

RET79

[RET79]

OK, my final call for this topic, if anyone can help me sort it I would be so grateful.

RET79

[Mark O'Brien]

Is there anything in that Excel 2000 book about arrays? That's going to be a better help then me.