vba delete

[s]

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

 

[Jim Cone]

Dim delrow As Long

delrow = 5
Rows(delrow).Delete
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html
Editorial review of Special Sort Excel add-in (30 ways to sort)




"s" <[email protected]>
wrote in message
news:acc46171-d1d8-44b7-97c1-08e5f0ac8d81@fk28g2000vbb.googlegroups.com...

 

[s]

Dim delrow As Long

delrow = 5
Rows(delrow).Delete
--
Jim Cone
Portland, Oregon USAhttp://www.contextures.com/excel-sort-addin.html
Editorial review of Special Sort Excel add-in (30 ways to sort)

"s" <[email protected]>
wrote in message

Thank you so much Jim.
You are my time saver.
David