#1
|
|||
|
|||
VBA - Deleting Rows (criteria based)
Hi all, I'm looking for some help using VBA to delete rows in an MSP I own.
There are tasks in my plan labelled as either "C" or "I" (as in Client or Internal) using a custom "text23" column. I'm currently having to manually delete, line by line those labelled "I" in order to send my client a sanitised version of the plan. I'm not quite at the stage yet to write my own VBA, but I'm certainly able to administer it. does anyone have an idea as to how the code to perform this task should look? |
#2
|
|||
|
|||
Hi,
Code:
Sub DeleteMsProjectTaskNeu() Dim proj As Project Dim t As Task Set proj = ActiveProject For Each t In proj.Tasks If t.Text1 = "I" Then t.Delete End If Next t End Sub Make sure you save your project before testing!! And maybe someone other has a look at this code too .-) HTH SW |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Deleting rows based on the text in certain cells VBA | ThisGuyJohn | Excel Programming | 5 | 02-03-2017 03:16 PM |
Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached. | phillipsdp | Excel | 1 | 11-09-2016 12:53 AM |
Copying rows through to another worksheet using criteria and VBA | alisun125 | Excel Programming | 1 | 06-01-2016 03:05 AM |
Excel VBA Macro - Deleting Specific Data based on criteria | MD011 | Excel Programming | 3 | 12-10-2014 02:15 AM |
Deleting rows with specific criteria | joflow21 | Excel | 9 | 11-22-2013 12:10 PM |