| 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 |
| 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) | |||
Threaded Mode
