Thread: vba delete
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
s[_5_] s[_5_] is offline
external usenet poster
 
Posts: 2
Default vba delete

Hello,
I want to write a vba that find row and delete it. I confirmed that
the match function returns some number OK, but delete function has
'13'runtime error-.
Could someone help me?
Thank you.
David

delrow = Application.WorksheetFunction.Match(partnumber &
Invoicenumber, Range("d:d"), 0)
Rows("delrow:delrow").Delete