### Excel COM

Posted:

**18 May 2018, 12:22**Hello,

I'm trying to find the equivalent of xlToRight for xlToLeft. Does anyone know what number should be defined as xlToLeft, and also where this number comes from? I'm trying to get to column A.
Any help with this is appreciated!

Thanks,

Vh

I'm trying to find the equivalent of xlToRight for xlToLeft. Does anyone know what number should be defined as xlToLeft, and also where this number comes from? I'm trying to get to column A.

Code: Select all

```
XL := ComObjActive("Excel.Application")
xlToRight := -4161 ;this works
XL.Selection.End(xltoRight).Select
;Need to find out the number for xlToLeft
xlToLeft := -###?
XL.Selection.End(xltoLeft).Select
```

Thanks,

Vh