how do i convert selection.end(xldown) to use in Progress
 

recording a macro, with the following, range(selection,
selection.end(xldown)).select I need to convert to use in a Progress program.
I came up with the following, but it gets an error on the xldown.

x1app:range(x1app:SELECTION, x1app:SELECTION:END(XlDown)):SELECT.

how do i convert selection.end(xldown) to use in Progress
 

maybe replace the xldown with it value as seen he

? xldown
-4121

--
Regards,
Tom Ogilvy


"Willis" wrote:

recording a macro, with the following, range(selection,
selection.end(xldown)).select I need to convert to use in a Progress program.
I came up with the following, but it gets an error on the xldown.

x1app:range(x1app:SELECTION, x1app:SELECTION:END(XlDown)):SELECT.

how do i convert selection.end(xldown) to use in Progress
 

Thanks Tom! That seems to work. Where do i find values for other codes, such
as xlByRows.. etc.?

"Tom Ogilvy" wrote:

maybe replace the xldown with it value as seen he

? xldown
-4121

--
Regards,
Tom Ogilvy


"Willis" wrote:

recording a macro, with the following, range(selection,
selection.end(xldown)).select I need to convert to use in a Progress program.
I came up with the following, but it gets an error on the xldown.

x1app:range(x1app:SELECTION, x1app:SELECTION:END(XlDown)):SELECT.

how do i convert selection.end(xldown) to use in Progress
 

In the object browser in the xlVBE or go to the immediate window like I
demonstrated.

--
Regards,
Tom Ogilvy



"Willis" wrote:

Thanks Tom! That seems to work. Where do i find values for other codes, such
as xlByRows.. etc.?

"Tom Ogilvy" wrote:

maybe replace the xldown with it value as seen he

? xldown
-4121

--
Regards,
Tom Ogilvy


"Willis" wrote:

recording a macro, with the following, range(selection,
selection.end(xldown)).select I need to convert to use in a Progress program.
I came up with the following, but it gets an error on the xldown.

x1app:range(x1app:SELECTION, x1app:SELECTION:END(XlDown)):SELECT.