End(3) for end(xlup)

[John Davis]

Hello All:

I read somewhere on the board where there were numbers which can be used to replace XLUP, XLDOWN, XLTOLEFT ect. I use the End(3). However, I'd like to know where to find the other numbers. When I search the board for same, I keep getting no matches found. Can someone enlighten me on where I can find this information?

 

[shg]

I always wondered why they bothered with those numberated thingies when you could just use plain old numbers ...

 

[RoryA]

I always wondered why they bothered with those numberated thingies when you could just use plain old numbers ...

I shall tweet this far and wide...

 

[shg]

xlOops

msoSorry

 

[mirabeau]

Thanks. I give up. I guess always use End(xlUp). But I know End(3) works. It has been tested, and I know I got the information from reading on the board. I can't remember where. And now I don't know why it works?

Maybe here (if you're thinking of recent posts)? http://www.mrexcel.com/forum/showthread.php?t=548296 Post#7

2 is not the same as xlDown, it's xlRight. 4 would be xlDown. You're still much better off using the enumeration though unless you are trying to make your code hard to read.

I guess you mean xlToRight.

Codes that are written for computers to use can be in any language the computer understands. My computer (if VBA) doesn't understand End(xlRight). It does understand End(2).

Codes for people to follow can/should be in any language the audience understands.

There's an old fable from Aesop with the general idea that if you try to please everybody, you may end up pleasing nobody.

I take the view that what you use in your codes, and/or expositions, depends entirely on the purpose for which these are written.

 

[Norie]

Eh, shouldn't it be xlToRight not xlRight?

 

[John Davis]

Maybe here (if you're thinking of recent posts)? http://www.mrexcel.com/forum/showthread.php?t=548296 Post#7


I guess you mean xlToRight.

Codes that are written for computers to use can be in any language the computer understands. My computer (if VBA) doesn't understand End(xlRight). It does understand End(2).

Codes for people to follow can/should be in any language the audience understands.

There's an old fable from Aesop with the general idea that if you try to please everybody, you may end up pleasing nobody.

I take the view that what you use in your codes, and/or expositions, depends entirely on the purpose for which these are written.

That's where I saw it. But when I searched for it - End(3) - I didn't receive any hits.

 

[John Davis]

Seriously? Do you not read your replies?

Sorry Rorya, didn't mean too not take into account your responses. Thanks for your input. Was being bombarded with replies at the time.

 

[mirabeau]

Eh, shouldn't it be xlToRight not xlRight?

Hi Norie,

Not sure if you were referring to my post, but for the avoidance of doubt you can look at the line immediately after my quote of rorya's post.

My next paragraph intended to use rorya's misprint.