| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a date & Selection.End(xlDown) | Excel Programming | |||
| Why doesn't Selection.End(xlDown).Select always work? | Excel Programming | |||
| Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming | |||
| Selection.End(xlDown) with Rows selected | Excel Programming | |||
| Selection.End(xlDown) with Rows selected | Excel Programming | |||
Hybrid Mode
