Im trying to find the translation code for XLprevious and
XlByColumns so that i can use the find function external
to excel itself. Ive found some codes such as xlright is -
4152 but i cant find the codes for the two named above

Does anybody know of these codes or of anywhere i can find
them.

Thanks alot.

Steve

Don't worry guys, somebody has helped me out. For future
reference both of the keywords have constants values of 2.


-----Original Message-----
Im trying to find the translation code for XLprevious and
XlByColumns so that i can use the find function external
to excel itself. Ive found some codes such as xlright is -
4152 but i cant find the codes for the two named above

Does anybody know of these codes or of anywhere i can
find
them.

Thanks alot.

Steve
.

You can find this information in the object browser or by using the
immediate window.

? xlPrevious
2
? xlbyColumns
2

--
Regards,
Tom Ogilvy


"Steve" wrote in message
...
Don't worry guys, somebody has helped me out. For future
reference both of the keywords have constants values of 2.


-----Original Message-----
Im trying to find the translation code for XLprevious and
XlByColumns so that i can use the find function external
to excel itself. Ive found some codes such as xlright is -
4152 but i cant find the codes for the two named above

Does anybody know of these codes or of anywhere i can
find
them.

Thanks alot.

Steve
.