View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Beeo Beeo is offline
external usenet poster
 
Posts: 3
Default Remove row in list based on user input

Hello



I have a data-list (excel 2003) with records and the following code

RowNo = Application.InputBox(Prompt:="Click on the row you wish to
delete", Title:="Delete row", Type:=1 + 2)
Selection.ListObject.ListRows(RowNo).Delete

But it's not working. Help appreciated (I'm new to this so please be
nice :)

Tia / Beeo