hi all,
I am fairly new to VBA / Macros and don't quite know enough to do it all myself yet.
I have found some code in a similar post that allows me to almost achieve the task I require but cant quite modify it to do what I require.
the code below will delete row 4 on every sheet, what i require is for the current selected row to be deleted or for the user to input a row number and then for that row to be removed.
Formula:
Sub Button1_Click()
Dim ws As Worksheet
Dim wb As Workbook
Set wb = ThisWorkbook
For Each ws In wb.Worksheets
ws.Rows("4").Delete
Next ws
Set wb = Nothing
End Sub
any help with this would be greatly appreciated.
Thanks
Turtlesrun
Bookmarks