how to get rid of blank rows.....

[Joy]

for some reason, after map, there are some blank rows in ms project
normally, they are at the end of file

they seem to have ID only, no wbs, no name, no duration... just blank row.
only ID, and seems I cannot delete ID, cos ID is read only...
how can I get rid of these blank rows??

thanks

 

[Jack Dahlgren MVP]

I think it was posted here a few days ago. Filter so no real tasks show then
do a selectall and delete.

-Jack Dahlgren

 

[John]

for some reason, after map, there are some blank rows in ms project
normally, they are at the end of file

they seem to have ID only, no wbs, no name, no duration... just blank row.
only ID, and seems I cannot delete ID, cos ID is read only...
how can I get rid of these blank rows??

thanks

Joy,
I explained how to do this in my response to your reply on the question
posted by karoc, "How to quickly remove blank rows using VBA".

John
Project MVP

 

[John]

I think it was posted here a few days ago. Filter so no real tasks show then
do a selectall and delete.

-Jack Dahlgren

Jack,
I answered this question in the original post. My first response was to
filter, but when I looked into it further, I realized a filter doesn't
work - at least I couldn't figure out a way to do it. So I posted an
alternate response. Joy just needs to follow up on that.

John

 

[Joy]

thank you very much John

Joy,
I explained how to do this in my response to your reply on the question
posted by karoc, "How to quickly remove blank rows using VBA".

John
Project MVP

 

[John]

thank you very much John

Joy,
You're welcome.

John
Project MVP