Refer to empty cell/row

R

Ruth

My goal is to move the activecell to the first empty task in the
project, in other words to the end of the project plus one. This is
what I've tried so far:


Dim t As Task
Dim num As Long
For Each t In ActiveProject.Tasks
num = t.UniqueID
If num = 0 Then
EditGoTo ID:=ActiveProject.Tasks(num).UniqueID
Call openpfile
Call buildparrays
End If
Next t


Project nevers finds a unique id of 0(zero) plus I've tried
NOT(isnumeric(t))


and I've also tried


t.name = ""

Is it possible to refer to an empty cell/row?
Any suggestions, your help is greatly appreciated!
 
J

Jan De Messemaeker

see my reply in the developer group (where I replied before you even posted
here!)
You can address an empty CELL in an existing task but IMHO not an empty ROW
(the related task is a Nothing object)
HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top