Missing number 100

[mso3]

Hi friends,

I want to create column wise list of addresses.
The code is working fine but missing number 100.

Please see the attached workbook and suggest me a correction.

Thanking you,

[TMS]

The code is working fine but missing number 100.

So, not really working fine then?

The second time that "Case = 2", Offset(0) takes you up to the last entry from the previous cut and overwrites it. Hence you lose the 100 entry. So, it's better to go with Offset(1) and check what row you get. First time through, it will be 2 (up to the top and down 1) so we need to adjust that to 1 because you have no headings.

Please Login or Register  to view this content.

Regards, TMS

[mso3]

Hi TMS,

Perfect! Thank you for explanation and solution.

Thank you.

[TMS]

You're welcome. Thanks for the rep.