Thread: Delete Row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JohnUK JohnUK is offline
external usenet poster
 
Posts: 173
Default Delete Row

Hi,
I am looking for a way to delete a row depending on a number in a range. For
example, if 124 was in the range, I would then want to delete row 124.
My Poor attempt:

Sub Macro22()
Row = Range("Row").Value
Rows(" & Row & ").Select
Selection.Delete
End Sub

Any help greatly appreciated
Regards
John