| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vba delete
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vba delete
On Mar 6, 9:55*am, "Jim Cone" wrote:
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" wrote in ... 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 Thank you so much Jim. You are my time saver. David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming | |||
![s[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
