| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select the last Cell of a selected Cellarea
Hallo,
if there are the following value in a column 23 21 32 Sum and I select with the mouse the area with first three rows (only the numerical values). Which command can I use to determine the rangeadress in a macro? The Command determine the whole range, including the string in the last line. This is not that I need. ..Range(ActiveCell.Address(0, 0) & ":a" & .Cells(Rows.Count, "A").End(xlUp).Row) Thanks, Ben |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select the last Cell of a selected Cellarea
..Range(ActiveCell.Address(0, 0) & ":a" & .Cells(Rows.Count,
"A").End(xlUp).Row-1) -- Regards, Tom Ogilvy "Ben" wrote in message ... Hallo, if there are the following value in a column 23 21 32 Sum and I select with the mouse the area with first three rows (only the numerical values). Which command can I use to determine the rangeadress in a macro? The Command determine the whole range, including the string in the last line. This is not that I need. .Range(ActiveCell.Address(0, 0) & ":a" & .Cells(Rows.Count, "A").End(xlUp).Row) Thanks, Ben |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select the last Cell of a selected Cellarea
This is not, that I need. Thats why I don't know if where one, two or five
.... lines at the buttom of the numerical values. The user marked the numerical values and I need to know the range, that is marked. With the command ..Range(ActiveCell.Address(0, 0) & ":a" & .Cells(Rows.Count, "A").End(xlUp).Row) I get all cells to the next empty cell in the column but not only the user-marked. Thanks, Ben "Tom Ogilvy" schrieb: ..Range(ActiveCell.Address(0, 0) & ":a" & .Cells(Rows.Count, "A").End(xlUp).Row-1) -- Regards, Tom Ogilvy "Ben" wrote in message ... Hallo, if there are the following value in a column 23 21 32 Sum and I select with the mouse the area with first three rows (only the numerical values). Which command can I use to determine the rangeadress in a macro? The Command determine the whole range, including the string in the last line. This is not that I need. .Range(ActiveCell.Address(0, 0) & ":a" & .Cells(Rows.Count, "A").End(xlUp).Row) Thanks, Ben |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select the last Cell of a selected Cellarea
Activewindow.RangeSelection
Sorry. Thats it, Ben "Ben" schrieb: This is not, that I need. Thats why I don't know if where one, two or five ... lines at the buttom of the numerical values. The user marked the numerical values and I need to know the range, that is marked. With the command .Range(ActiveCell.Address(0, 0) & ":a" & .Cells(Rows.Count, "A").End(xlUp).Row) I get all cells to the next empty cell in the column but not only the user-marked. Thanks, Ben "Tom Ogilvy" schrieb: ..Range(ActiveCell.Address(0, 0) & ":a" & .Cells(Rows.Count, "A").End(xlUp).Row-1) -- Regards, Tom Ogilvy "Ben" wrote in message ... Hallo, if there are the following value in a column 23 21 32 Sum and I select with the mouse the area with first three rows (only the numerical values). Which command can I use to determine the rangeadress in a macro? The Command determine the whole range, including the string in the last line. This is not that I need. .Range(ActiveCell.Address(0, 0) & ":a" & .Cells(Rows.Count, "A").End(xlUp).Row) Thanks, Ben |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select the last Cell of a selected Cellarea
Or just selection in the scenario you describe.
-- Regards, Tom Ogilvy "Ben" wrote in message ... Activewindow.RangeSelection Sorry. Thats it, Ben "Ben" schrieb: This is not, that I need. Thats why I don't know if where one, two or five ... lines at the buttom of the numerical values. The user marked the numerical values and I need to know the range, that is marked. With the command .Range(ActiveCell.Address(0, 0) & ":a" & .Cells(Rows.Count, "A").End(xlUp).Row) I get all cells to the next empty cell in the column but not only the user-marked. Thanks, Ben "Tom Ogilvy" schrieb: ..Range(ActiveCell.Address(0, 0) & ":a" & .Cells(Rows.Count, "A").End(xlUp).Row-1) -- Regards, Tom Ogilvy "Ben" wrote in message ... Hallo, if there are the following value in a column 23 21 32 Sum and I select with the mouse the area with first three rows (only the numerical values). Which command can I use to determine the rangeadress in a macro? The Command determine the whole range, including the string in the last line. This is not that I need. .Range(ActiveCell.Address(0, 0) & ":a" & .Cells(Rows.Count, "A").End(xlUp).Row) Thanks, Ben |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when I select one cell, why are 5 more cells selected below | Excel Discussion (Misc queries) | |||
| List to select up to 6 selected responses | Excel Discussion (Misc queries) | |||
| if i select a cell then i want row containing that cell selected | New Users to Excel | |||
| Can you select a chart but not see it's selected? | Charts and Charting in Excel | |||
| How do I de-select a selected row? | Excel Discussion (Misc queries) | |||
Hybrid Mode
