How to Insert Row Number Across Multiple Worksheet at same cell.

[sagar kathiriya]

Hello,
I want to add a row number, in my multiple worksheets in the same cell.

for ex. I have 50 sheets in a workbook, now I have to add row number in every worksheet's cell "B11". in first sheet i want 1 and in second 2 and like 3,4,5...50. at same "B11" cell. please help me.....

 

[mumps]

Try:

Sub InsertNUmber()
    Application.ScreenUpdating = False
    Dim ws As Worksheet, x As Long: x = 1
    For Each ws In Sheets
        ws.Range("B11") = x
        x = x + 1
    Next ws
    Application.ScreenUpdating = True
End Sub

 

[sagar kathiriya]

Yes, It's work... Thank u so much.

 

[mumps]

You are very welcome.