Delete a row that the active cell is in
Posted by John Gun on February 11, 2002 5:20 PM
How can a write a macro that will goto a specified cell (specified by the user) and then delete that row.
Thanks very much
John
Posted by DRJ on February 11, 2002 7:24 PM
Hi
Sub DeleteIt()
MyCell = inputbox("What row do you want to delete")
rows(mycell).delete
end sub
HTH
DRJ
