Good Day Group,

Any hints on this problem;

I have different text in Range("A1:C1500). Is there a quick way
to insert the individual rownumber for each row of this range in
Range("D1:D1500") without looping trough the entire range?

Best Regards

CG Rosén

maybe
=row() and copy down.

--
Don Guillett
SalesAid Software

"CG Rosén" wrote in message
...
Good Day Group,

Any hints on this problem;

I have different text in Range("A1:C1500). Is there a quick way
to insert the individual rownumber for each row of this range in
Range("D1:D1500") without looping trough the entire range?

Best Regards

CG Rosén

If you're looking for a programming solution:

With Range("D1:D1500")
.Formula = "=ROW()"
.Value = .Value
End With


In article ,
"CG Rosén" wrote:

Good Day Group,

Any hints on this problem;

I have different text in Range("A1:C1500). Is there a quick way
to insert the individual rownumber for each row of this range in
Range("D1:D1500") without looping trough the entire range?

Best Regards

CG Rosén