Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS Project 2003 Macro Help Needed <URGENT> !!!!!

Status
Not open for further replies.

rakirobert

Programmer
Aug 22, 2005
1
0
0
US
Hi,

I have never used MS Project 2003 or its predecessors. I am given a task to write a macro that validates data that has been inputed.

I was wondering how I can get the number of rows that have been filled up with data. "Last row of data" in another way of saying it!

in excel I know the code is the following:

Sheets(sheetName).UsedRange.Rows.Count

what is the equivalent for MSProject 2003

any good links for getting info on such help!
 
Does Project 2003 have a Visual Basic editor like Excel and Word? If so, you might be able to record a macro, and then look at it's code. Once you know some of the syntax, you might be able to check the VBA help for some keywords.

Hope this helps,
Joseph
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top