=ROW()-1 to assign numbers to several hundreds of rows, is there a macro that can help me cut the entire row leaving column A (Row #) out?

[GabyS2023]

I apologize in advance if not clear explanation,

I'm using =ROW()-1 to assign numbers to several hundreds of rows, is there a macro that can help me cut the entire row leaving column A out without Ctrl + Shift? this is to paste in a different sheet of the workbook. thank you

 

[eiloken]

i don't know this is what you want or not:

Sub test()
    Dim lr As Long
    Dim cll As Range
    lr = Sheet1.Cells(Rows.Count, 2).End(xlUp).Row ' find last row of colum b in sheet data
    If lr < 2 Then Exit Sub
    For Each cll In Sheet1.Range("B2:B" & lr)
        Sheet1.Range(cll, Sheet1.Cells(cll.Row, Columns.Count).End(xlToLeft)).Cut Destination:=Sheet2.Range(cll.Address) 'cut from column B to last column include data and paste to sheet2, change it to your
    Next cll
End Sub