Counted column without loop

[vizzkid]

Is there a way to create a "counted" column, let's say 0-200 without using a loop? I want column A to have numbers from 0-200.

[TMS]

One way:

Please Login or Register  to view this content.

Regards, TMS

[vizzkid]

I'd kinda consider that a loop, but nevermind, it works. Thanks!

[TMS]

Why would you consider it a loop? It doesn't have a counter, it doesn't have any loop code: No "For ... Next", "For Each", "Do While" ..., whatever.

[vizzkid]

hmm.. well, i guess your right

[vizzkid]

oops, i was i bit quick to judge the code as complete.. When using the code i get:

Please Login or Register  to view this content.

any suggestions?

[TMS]

any suggestions?

No, worked fine for me on an empty sheet. Please post a sample workbook that exhibits the problem.

All it does is put a seed value, 0, in cell A1 and a formula to increment the value by 1 in cells A2:A201. It immediately converts the calculated formulae to values.

Interesting effect though ... I'd like to understand why it's doing that.

Regards, TMS

[vizzkid]

Very weird.. works on an empty sheet for my aswell.. Afraid i can't post my original document, so i cant reproduce the problem for you. I solved the issue by using some ugly code:

Please Login or Register  to view this content.

[TMS]

Clearly, your real life scenario is subtly different to the question you originally asked.

[vizzkid]

Well actually not.. Making it even more strange