Ubound for variant not working for some reason, can anyone see why?

Discussion in 'Excel Programming' started by Mark Stephens, Apr 23, 2014.

  1. I have an array inside a variant which has 6,000 rows and two columns, when I try to read its Ubound value it returns 3! There's really nothing to the code so I know there's not too much to go on:

    Dim lNoRowsExistingData As Long

    lNoRowsExistingData = UBound(pvarrCht1, 1)


    I checked the array (pvarrCht1) just before the code executes it appears to be correct (with 600 rows, two columns),anyone any idea why this doesn't work it's very bafflng?

    Any help much appreciated, kind regards, Mark
     
    Mark Stephens, Apr 23, 2014
    #1
    1. Advertisements

  2. Re: Ubound for variant not working for some reason, can anyone seewhy? SOLVED

    On Wednesday, 23 April 2014 10:42:29 UTC+7, Mark Stephens wrote:
    > I have an array inside a variant which has 6,000 rows and two columns, when I try to read its Ubound value it returns 3! There's really nothing to the code so I know there's not too much to go on:
    >
    >
    >
    > Dim lNoRowsExistingData As Long
    >
    >
    >
    > lNoRowsExistingData = UBound(pvarrCht1, 1)
    >
    >
    >
    >
    >
    > I checked the array (pvarrCht1) just before the code executes it appears to be correct (with 600 rows, two columns),anyone any idea why this doesn't work it's very bafflng?
    >
    >
    >
    > Any help much appreciated, kind regards, Mark


    Sorry realised my error I didn't dimension the array properly!
     
    Mark Stephens, Apr 23, 2014
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.