VBA - Deleting Rows (criteria based)

		Microsoft Office Forums > Microsoft Office > Project
VBA - Deleting Rows (criteria based)

FAQ

Thread Tools

Display Modes

07-31-2017, 08:55 AM

silentwolf silentwolf is offline

Windows 7 64bit VBA - Deleting Rows (criteria based)

Office 2010 64bit

Novice

Join Date: Dec 2016

Location: Austria

Posts: 16

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

I just tested this code and it works for me but I am not that good in ms project VBA so I hope this works for you too!

Make sure you save your project before testing!!
And maybe someone other has a look at this code too .-)

HTH

SW

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:55 PM.