Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete blank rows
It would not be possible to merge 9 columns in to 1 but all the data to appear in column A same row as original, unless you have sporadic data e.g column F data in Row 6 no other columns have data in row 6....etc How is the data set up? is it like i described? If it is then: Sub blank_remove() With ActiveSheet.UsedRange ..SpecialCells(xlCellTypeBlanks).Delete shift:=xlToLeft End With End Sub -- The Code Cage Team Regards, The Code Cage Team www.thecodecage.com ------------------------------------------------------------------------ The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=11097 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Rows if any cell in Column H is blank but do not Delete Fir | Excel Programming | |||
How do I delete blank rows (rows alternate data, blank, data, etc | Excel Discussion (Misc queries) | |||
Delete Blank rows | Excel Programming | |||
Delete blank row only if 2 consecutive blank rows | Excel Programming | |||
help delete blank rows | Excel Programming |