how to refer last row value through the macro

C

chitra

i am going to refer the project row through the macro.So that how can i refer
the last row value.It is varing one.

how to use the string comparisons.
 
R

Rod Gill

Hi,

Usually you don't need or want to refer to rows. Better to use:
ActiveProject.Tasks(ActiveProject.Tasks.Count).ID to get the ID of the last
Task or

ActiveProject.Tasks(ActiveProject.Tasks.Count).Text1="Hello World"

to set Text1 for the last Task.
 

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

Similar Threads

Macro to select and delete levels of a document 2
Drop down list control value in vba 2
Need Help with a VBA subroutine 0
Flag duplicate emails 1
New computer, how do i move outlook 365 ENTIRELY? 0
How to implement two shifts per day with multiple teams 0
Using project as a resource tracker 0
Word macro that can call cells out of Excel for a find and replace 0

Top