.End(xlDown) and former versions of Excel

[jungix]

Hi,

I wrote a macro in Excel where I needed to use the

Range("A1").End(xlDown).Row


It worked perfectly by me, but it's not working at my friend's place with a former version of Excel. Is it normal? Is it another way of doing the same thing in former versions of Excel?

[Bob Phillips]

Hi,

I wrote a macro in Excel where I needed to use the

Range("A1").End(xlDown).Row

It worked perfectly by me, but it's not working at my friend's place with a former version of Excel. Is it normal? Is it another way of doing the same thing in former versions of Excel?

That should work. What happens to your friend, an error or just goes to the wrong place?

[jungix]

En error (debug) but she doesn't know anything about VBA. The problem might be that macros are disabled, I'll try to look into it and at least get from her an error name.

[Bob Phillips]

En error (debug) but she doesn't know anything about VBA. The problem might be that macros are disabled, I'll try to look into it and at least get from her an error name.

It could be a MISSING reference. Get her to look at Tools>References in the VBIDE, and see if any items are maked with MISSING. If so, uncheck them.