Hi,
I'm developing some extra coding onto the end of Jack's Heirarchy macro in
Microsoft Project. The macro exports the project task information into Excel,
but doesn't format it too neatly. I am adding some code to complete some
formatting steps so that I do not have to format the spreadsheet every time i
run the macro.

I have come up against a little bit of an annoyance, though, and as I'm no
expert, would like some help in resolving it.

The first line of code I have added is:

Range("A:A").Select

The first time I run the code I get no errors (the code is run from MS
Project). The second time I run the code, I get the following error:

Run Time Error '1004':
Method 'Range' of Object '_Global' failed

When I debug, the first line of my code above is highlighted.

If I end, and run a third time, it runs ok. But every alternate time I run
the code, I get the same error.

I have selected the Excel object library reference, else it wouldn't run at
all.

Can anyone point me towards why I get this error?

Thanks
James.