Setting a valuie in a range of cells

[Peter Rooney]

Jack gave me a useful tip in my quest to filter my plan according to which of
four teams in my department are responsible for carrying out each task.
I have added a new text field into my plan, and now need to input the name
of the appropriate team into each cell for each task and its sub tasks.

I expand the task to level 9, then select all the appropriate tasks.
If I run the code below, the value is input into the first cell in the
selection, but not all the others. What am I doing wrong?

Sub SoftwareMgtTeam()
For Each InputField In ActiveSelection.Tasks
SetInputField Field:="Text5", Value:="SoftwareMgt"
Next
End Sub

Thanks in advance

Pete

 

[Peter Rooney]

The system said that this hadn't been sent - but it obviously had - please
ignore.

Incidentally, is there any way to delete these threads once somebody's
answered your query?

Pete

 

[John]

Pete,
The answer to your question about deleting threads is no, at least not
by the general public, and that is good. Part of the reason for having a
public newsgroup is for the benefit of all users. For example, if
someone else had a similar problem to yours, they might not see the
reply if you were able to delete the post as soon as you see the reply.
Messages in this newsgroup are truncated after about a week (at least
with my newsreader) however, Google retains the full history as far back
as you want to go.

John