VBA - problem copying data from storage array to sheet array

[jtown269269]

I am trying to replicate what a Data Table does in excel in VBA. I have got the code working as I want thus far however when I copy data out of the temporary storage array it is offset by 1 Column and 1 Row.

I cannot figure out what the issue is? Thanks in advance.

Please Login or Register  to view this content.

[Greg M]

Hi there,

It's late here, so I'm not claiming to have thought this one through fully, but what goes through my mind is that the statement:

Please Login or Register  to view this content.

creates a zero-based array,

while the statement:

Please Login or Register  to view this content.

creates a one-based array.

This might account for your "one row off, one column off" situation.


Hope this helps.

Regards,

Greg M



P. S. To make the two arrays consistent you can use:

Please Login or Register  to view this content.

[jtown269269]

That worked perfectly! Thank you!

[Greg M]

Hi again,

Many thanks for your feedback.

You're welcome - glad I was able to help.

Regards,

Greg M