| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Selection to First Empty Row
I'll try to help, but I still have a bit of trouble to understan
without any sample data: Eg What Value is contained in the Listbox? Then Range("Selectedlink") seems to be a named range..... Well anyways. This might help you: When I have a contineous list of values, and want to find the nex available row, I use this: Code ------------------- Range ("A1").select '(top left corner of my list) ActiveCell.Offset(ActiveCell.CurrentRegion.Rows.Co unt, 0).Select ------------------- -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
| Remove empty cells from named list / validation list | Excel Worksheet Functions | |||
| validation list--list depends on the selection of first list | New Users to Excel | |||
| limit cell list selection based on the selection of another list | Excel Worksheet Functions | |||
| Selection of non-empty cells | Excel Programming | |||
![Markus Stolle[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
