xlVBAlignTop etc. Stopped Being Recognized

[roadkill]

I am consolidating macros in one module for a project template. Some copied
macros are no longer working because things like xlVAlignTop and the Cells
object are no longer recognized. If I load the template and the project that
originally (and still) contained the macro and run one then the other, the
original runs fine but the one in the template still fails (e.g. regarding
xlVAlignTop, I get an "unable to set vertical alignment property..." error).

What's going on? Is there an add-in or library that's missing from my
template (if so how do I add it in)?

Thanks in advance,
Will

 

[Jan De Messemaeker]

Hi,
Make sure that in the VB Editor, Tools, References, the reference to the
right version of Excel objects is active.
HTH

 

[roadkill]

That was it. Thanks!
- Will

Hi,
Make sure that in the VB Editor, Tools, References, the reference to the
right version of Excel objects is active.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620