View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
E Oveson[_3_] E Oveson[_3_] is offline
external usenet poster
 
Posts: 12
Default Deleting a User Input Row

This should work:

Rows(RName).Delete

-Erik

"Dan" wrote in message
...
I set up a InputBox to capture the ROW that the user would
like to Delete, If Input = 6 then ClearContents of the
row, etc. I started like this:

Dim RName as Interger
RName=InputBox("Enter Row to be deleted", "Row Number")

How do I use the "RName" to select and delete the entire
row?

I used the RName like this:

If RName = 6 Then