compile error on simple End.xldown code

[Gti182]

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?

Please Login or Register  to view this content.

[royUK]

Works fine, where have you written the code?

[romperstomper]

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

[Gti182]

Just uploaded it in the usual module? I've attached a screenshot of where it's gone wrong.

[royUK]

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

[romperstomper]

Don't call the sub XLDown!

[Gti182]

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

[romperstomper]

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.

[Gti182]

cheers for that! Really helpful bit of info there.