| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select the next row after xldown range
I want to highlight column A all the way down to the end of its curren
data range and then select the first row after the end of the dat range. Assuming column A has 14 rows of data I want to then select th 15th row (i.e. A15). What do I have to add to the end of this code to do that? Range("A1").Select Range(Selection, Selection.End(xlDown)).Select Thank -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select the next row after xldown range
Hi
try Range(Selection, Selection.End(xlDown).offset(1,0)).Select -- Regards Frank Kabel Frankfurt, Germany I want to highlight column A all the way down to the end of its current data range and then select the first row after the end of the data range. Assuming column A has 14 rows of data I want to then select the 15th row (i.e. A15). What do I have to add to the end of this code to do that? Range("A1").Select Range(Selection, Selection.End(xlDown)).Select Thanks --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select the next row after xldown range
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use xldown to select a range of cells | Excel Discussion (Misc queries) | |||
| When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
| End(xlDown) not working? | Excel Discussion (Misc queries) | |||
| xldown and xlright | Excel Programming | |||
| ActiveCell.End(xlDown).Select not working consistently | Excel Programming | |||
![ExcelMonkey[_108_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
