ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   XlPrevious Translation Code (https://www.excelbanter.com/excel-programming/288013-xlprevious-translation-code.html)

Steve Barwood

XlPrevious Translation Code
 
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

steve

XlPrevious Translation Code
 
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
.


Tom Ogilvy

XlPrevious Translation Code
 
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
.





All times are GMT +1. The time now is 04:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com