Calling Mark o brien!
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Calling Mark o brien!

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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!

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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)

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

    What the hell are you doing up at 2.30am?

  5. #5
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  8. #8
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  9. #9
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

    RET79

  10. #10
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com