Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Range
I have a list of names. The names have blanks in between them.
I want to put these names into a list with no gaps. Any Idea's? The list needs to be one cell after the other -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Range
Hi
personally i would just sort the list - this will put all your gaps at the bottom Cheers Julie "ianripping " wrote in message ... I have a list of names. The names have blanks in between them. I want to put these names into a list with no gaps. Any Idea's? The list needs to be one cell after the other. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Range
Sub ManageList()
Selection.Copy Destination:=Selection.Offset(0, 1) Selection.Offset(0, 1).SpecialCells(xlBlanks).Delete Shift:=xlShiftUp End Sub -- Regards, Tom Ogilvy "ianripping " wrote in message ... I have a list of names. The names have blanks in between them. I want to put these names into a list with no gaps. Any Idea's? The list needs to be one cell after the other. --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Range
Sub DeleteCell()
Range("A:A").SpecialCells(xlCellTypeBlanks).Delete End Sub Or if you have more than one column of names just highlight the range and: Sub DeletCellsInRange() Dim MyCells As Range For Each MyCells In Selection.Areas With MyCells .SpecialCells(xlCellTypeBlanks).Delete End With Next MyCells End Sub Mike Q. -----Original Message----- I have a list of names. The names have blanks in between them. I want to put these names into a list with no gaps. Any Idea's? The list needs to be one cell after the other. --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
advanced filter dialog box, "List Range" list two ranges? | Excel Worksheet Functions | |||
List Box - For Input Range can I use named range in another workbo | Excel Worksheet Functions | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Condensing a list/range with blank cells to a new list/range without blanks | Excel Worksheet Functions | |||
how do i define a range as a list when there is no list option in. | Excel Worksheet Functions |