Thread: Macro to enter record number in column A
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Papou Papou is offline
external usenet poster
  
Posts: 67
Default Macro to enter record number in column A
Hello
Sub testnumber()
With Worksheets("M_Formatted Data")
For i = 2 To .Range("D65536").End(xlUp).Row
Cells(i, 1).Value = i - 1
Next i
End With
End Sub

HTH
Cordially
Pascal


Reply With QuoteReply With Quote