Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Project

LinkBack Thread Tools Display Modes
Old 07-31-2017, 06:35 AM
BobbyG BobbyG is offline Windows 7 32bit Office 2010 32bit
Join Date: Mar 2015
Location: York - UK
Posts: 3
BobbyG is on a distinguished road
Default 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?
Reply With Quote
Old 07-31-2017, 08:55 AM
silentwolf silentwolf is offline Windows 7 64bit Office 2010 64bit
Join Date: Dec 2016
Location: Austria
Posts: 16
silentwolf is on a distinguished road


Sub DeleteMsProjectTaskNeu()
    Dim proj As Project
    Dim t As Task
    Set proj = ActiveProject

        For Each t In proj.Tasks
            If t.Text1 = "I" Then
            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 .-)


Reply With Quote

Thread Tools
Display Modes

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

All times are GMT -7. The time now is 02:40 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft