Catia Macro Excel .End(xlDown)

[ubengineer]

I have a Catia macro that opens an excel file and trying to get it to find the last cell in a Column by using .End(xlDown).Row. I found a thread on here that has .End(xlUp) and tried even running that entire code and still the code even their code from

http://www.eng-tips.com/viewthread.cfm?qid=354366

is getting hung on that line. I am getting an error message: Run-time error 1004 Application-defined or object-defined error. Does any one have any ideas how to do a .End(xlDown) in catia for excel?

 

[ubengineer]

Figured it out. Had to type Const xlDown=-4121 at the beginning.