compile error on simple End.xldown code

Hi peeps,

Just trying to recreate one of the examples in the excel bible 2003 during lunch but I'm getting a compile error (expected function or variable) on the following bit of code and can't seem to figure out why. The error highlights the "XlDown" portion of the code as erroneous. I copied it straight from the book?

Range(ActiveCell, ActiveCell.End(XlDown)).Select

Works fine, where have you written the code?

Just pasted that into a test sub and it compiles fine, as expected. Do you have a sub or module called XLDown?

Looks like it's in the Sheet module not a standard module

Don't call the sub XLDown!

Ok renamed the sub to "macro1" and that sorted it. Why would the macro name have any influence on the actual code?

You have a routine called XLDown that then refers to XLDown, so the compiler gets confused - it's expecting a constant (or function) to be the argument of the End method, not the name of a subroutine.