range question

[CG Rosén]

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("D11500") without looping trough the entire range?

Best Regards

CG Rosén

 

[Don Guillett]

maybe
=row() and copy down.

 

[JE McGimpsey]

If you're looking for a programming solution:

With Range("D11500")
.Formula = "=ROW()"
.Value = .Value
End With