Array length

[mreFF]

The myRows() array got some value like: 1, 2, 3, 4, 5
In my First executed code all works and gives me the right array length.
'Sorry can't show you the data..


...At this time i would like to see what is left of it by Calling the updateRecords.

Why does it execute but don't gives me the array length there?
Are there better ways to see the Array length?

Please Login or Register  to view this content.

[6StringJazzer]

The argument to CountA must be a Range object. Sometimes documentation says that it can be an array, but that is an Excel sheet array, not a VBA array variable.

In your case, the array starts at element 0, so the number of elements is the upper bound + 1.

Please Login or Register  to view this content.

If you have bounds that are not the default, you need this:

Please Login or Register  to view this content.

[mreFF]

I start with this this code, wich runs good:

Please Login or Register  to view this content.

Lets say MsgBox (max_user_items) got 8
From there I walk trough the rows.
This runs good. When adding a row the Array is still 8.
Thats where the Call updateRecords is needed.

How to set this up that it outputted 7 and after adding a new row 6, etc.

[TMS]

Not entirely sure why you need to use an array.

Please Login or Register  to view this content.

This could be made into a function and, if required, called from the worksheet.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This relates specifically to column A although it could be amended to work with any range.


Regards, TMS

[mreFF]

thnx for the inputs. What code is for output the last array item?

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[mreFF]

Sorry, I'm strugling with my own code first.

At this moment its hard to find the latest array.
I think I started with two different wrong numbers. Zero and One.
I can't find where this bug is. Everything is working fine, except the latest handling.

Please Login or Register  to view this content.

Above do the trick for everything but.... this:

Ive found out that this code below will allways be one number short.
It never match to the exact value.

Please Login or Register  to view this content.

Changing to this won't help neither.
whoIsOn +1 = max -1
whoIsOn = max
whoIsOn = max -1

If I do this all they futher actions are mixed up! ^&@*##@^$

What goes wrong!>&#$(@

[TMS]

OK, I'm struggling too. I have no idea what your data looks like, what the end to end code looks like, or what you are trying to achieve.

When you are given code, you know all this ... but we don't. So it's hard to work out what it needs to do.


Regards, TMS

[mreFF]

OUTPUT:

Item whoIsOn: 0 - MAX ITEMS 6
Item whoIsOn: 1 - MAX ITEMS 6
Item whoIsOn: 2 - MAX ITEMS 6
Item whoIsOn: 3 - MAX ITEMS 6
Item whoIsOn: 4 - MAX ITEMS 6 = Latest record ???????????
Item whoIsOn: 5 - MAX ITEMS 6 = Latest record ???????????

Ok Item whoIsOn: 4 is exctually whoIsOn 5 becuz it starts @ zero. And than max -1 = one less if there are 6 items in this case.
So 5 is indeed the latest record
Whats the why to solve this? To get a proper value "Latest record" in only Item whoIsOn: 5 - MAX ITEMS 6