Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > Setting a valuie in a range of cells
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 1st June 11:46
peter rooney=^(읊.Ȩɢr,\
External User
 
Posts: 1
Default Setting a valuie in a range of cells



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
  Reply With Quote


  sponsored links


2 1st June 11:46
peter rooney=^(읊.Ȩɢr,\
External User
 
Posts: 1
Default Setting a valuie in a range of cells



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
  Reply With Quote
3 1st June 11:46
john
External User
 
Posts: 1
Default Setting a valuie in a range of cells


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
  Reply With Quote
Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666