PDA

View Full Version : Filldown in Gantt Chart view using VBA



k3vsmith
02-17-2016, 08:43 AM
I have several columns in my gantt chart view. Three of the columns are filtered so I can see a specific view. On the last column I would like to enter the value "constraint added" down the entire column to last row in the view. I only want "constraint added" entered for this column in the current view. I dont want constraint added copied down to rows outside of this filtered view. Can you assist with code to do this?

Here is my attempt:
Sub sbText11toConstraintAdded()
Dim lasttaskrow As String
lasttaskrow = ActiveProject.Tasks.Count

SelectTaskField Row:=0, Column:="Text11"
SetTaskField Field:="Text11", Value:="Constraint Added"
SelectTaskField Row:=0, Column:="Text11", Height:=lasttaskrow
FillDown
End Sub

This copies it down but not to all in current view?