Excel.range

[MarkC]

What is the problem here:

Compile Error: User-defined type not defined.

Falls over at:

DIM xlrange As excel.Range

Cheers,
Mark

 

[Jan De Messemaeker]

Hi,

In VB Edoitor, Tools, References, check the reference for excel.

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

 

[Rod Gill]

For that to work you need to have the Excel Object added as a reference
(Tools, References in the VBE).

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com