Re: An unexpected error occured with the method

So why are you selecting the columns? If the indicator column isn't visible
your code will crash, one of many reasons why moving the cursor in a vba
macro is poor programming, slow and expensive to develop!!

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


"Daniel Engelschalt" <Daniel.Engelschalt@xxxxxxxxxxxxxx> wrote in message
news:1150108672.907956.302130@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Gill,

Thank you for your fast response.

My function starts with:

SelectTaskColumn Column:="Indicators", Additional:=3

as the very first command.

The goal is to mark all tasks, outline and analyze them and after a
task has been analyzed mark these that match a given condition.
To mark tasks I use SelectTaskField for which I first have to outline
all tasks (row).
A command like activeproject.Tasks(currentTask.ID).font.color=1 could
be helpful, but I haven't found something like this.

Daniel

Rod Gill wrote:
Hi,

What's the code that causes the problem? Moving the cursor to tasks to
read/write data is completely unnecessary and causes slow and problematic
code. For example if you try to move to a task that has been filtered out
or
to a sub-task that is not visible your code errors out.

Use:
activeproject.tasks("My Task").work=8*60

Don't move to the task then edit, it simply isn't robust!

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more



.

Relevant Pages

  • Moving the cursor around with a macro....
    ... on the moving and selecting of cursor and cell locations programmatically ... (Macro or VB). ...
    (microsoft.public.excel.programming)
  • Re: Select problem
    ... put my cursor on a cell, instead of selecting that cell, it selects 5 or 6 ... without moving the entire area of my information? ...
    (microsoft.public.excel)
  • Re: [9fans] Parallels v 3 and Plan 9, anyone tried yet?
    ... page 'Installing in parallels desktop on Mac OS X' ... but the mouse cursor does funny things. ... moving mouse moving south-east and can erase by moving mouse north-west. ... hget -o opens existing file without truncate, ...
    (comp.os.plan9)
  • Re: ive got a simple excel problem that needs solving...
    ... Each time you hit TAB, ... >>> record collection as they don't make Access for the Mac unfortunately. ... >>> Comment) i want the cursor to jump to the 1st column of the next row ... >>> (instead of moving the cursor down with the arrow and key's and then ...
    (microsoft.public.excel.misc)
  • rubberband effect with text placement
    ... I need some artical or feedback on text with moving cursor. ... Text string will be retreived from dialog edit box and seen moving with ... I assume ROP functions wont help ...
    (microsoft.public.vc.mfc)
Quantcast