am trying to get the following code to look up a name entered in the text box
, then return the value of th row number as X . rather than users having to
enter the row number (have tried using the match function but cant seem to
get it to work in vb),

thanks in advance

Sub DeleteRequestedRowsInAllSheets()
Dim sh As Worksheet

x = InputBox("Please Enter The Line Number Of The Person To Delete From This
Record")

Dim n As Single

For Each sh In Worksheets(Array("Jan", "Feb", "March", "april", "may",
"June", "July", "Aug", "Sep", "Oct", "Nov", "Dec", "Overview"))
sh.Rows(x).delete
Next sh

End Sub