Overflow error

Hi everyone,

A genius on this forum gave me this awesome code.
It basically splits multiple values in a row to individual rows, with each row only having one of these values.

So if in Column H2 and I2 are a value it creates an extra row for I2, clearing cell I2 and H3.

I tried to use this code on another file but i get the error: Run-time error '6': Overflow

This is the code.

Please Login or Register  to view this content.

It stops at: x = .Value

Does anyone know whats wrong or how to fix this?

Thanks for all the help.

try

Please Login or Register  to view this content.

Hi Graym,

It now gives a "compile error, expected array" because of this line:

Please Login or Register  to view this content.

Highlighting the furst UBound

How big is the current region? Might be to do with array limits.

sorry didn't see array
maybe -

Please Login or Register  to view this content.

Hi
The range now is A1:Z198

OK not that then. Fumbling in the dark really, but do you have any errors in your range - can you post a workbook?

I'll try to make something because i'm working with sensitive data

In attached file i would like to apply the script.

I see that the array should be (5, 6, 7)

Please Login or Register  to view this content.

Funny how when i try this in the attached doc the script works, but in my real file it gives this overflow error.....

I think it must be related to your actual data because that code runs without error on your sample. Have a look for odd values and hope somebody else happens by with a bright idea.

Hi StephenR

Thanks for your answer.
Do you perhaps know another script that'll do the same trick?