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 |
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 . |
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