MSProject 2003 - Why cant I select more than 10 row instances?

[seanpears99]

Hi everyone

I am writing a VBA extract program over one of my projects to do
selectrow command if the WBS matches a list of snapshot IDs for extrac
to an update report following use fo the editcopypicture command.

I have found tho that I can only perform the selectrow command 10 time
and then I get a runtime error.

Is there any way to increase this (I also notice when you try an
highlight more than 10 instances (it wont let you)

Thanks in advance

Sea

 

[Rod Gill]

Sorry, it's a built in limitation.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Hi everyone

I am writing a VBA extract program over one of my projects to do a
selectrow command if the WBS matches a list of snapshot IDs for extract
to an update report following use fo the editcopypicture command.

I have found tho that I can only perform the selectrow command 10 times
and then I get a runtime error.

Is there any way to increase this (I also notice when you try and
highlight more than 10 instances (it wont let you)

Thanks in advance

Sean


--
seanpears99
------------------------------------------------------------------------
seanpears99's Profile: http://forums.techarena.in/members/146080.htm
View this thread: http://forums.techarena.in/microsoft-project/1260408.htm

http://forums.techarena.in


__________ Information from ESET Smart Security, version of virus
signature database 4524 (20091019) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4524 (20091019) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[seanpears99]

Hi Rod

Could you help with the following:-

Hi everyone

Due to task selection limitations as posted previously, I wonder i
anyone an help.

I am now having to apply a filter in VBA (using one I have alread
created) and then work down the output (if unique id <> blank a = a +
then select rowid + height (a)) to select all of the tasks for
editcopypicture object to copy out to a gif.

The problem is, when I apply the filter and scan for the end of th
last task, it isnt using the filtered output so I am going way pas
where I need to select to extract.

Is there a used lines count which will work when the filter is on?

(I normally use Excel VBA so I am struggling)

Many thanks

Sea