![]()
Sub Sequence_Numbering() Range("A4").Value = 1 Range("A4:A" & Range("B" & Rows.Count).End(xlUp).Row).DataSeries Rowcol:=xlColumns, Type:=xlLinear, Step:=1, Trend:=False End Sub
![]()
Sub Sequence_Numbering() Range("A4").Value = 1 Range("A4:A" & Range("B" & Rows.Count).End(xlUp).Row).DataSeries Rowcol:=xlColumns, Type:=xlLinear, Step:=1, Trend:=False End Sub
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank you, worked perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks