Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Please help for the above subject.
the following module only able delete the empty row at Column A only. Sub DeleteEmptyRow() Dim cRows As Long Dim i As Long cRows = Cells(Rows.Count, "A").End(xlUp).Row For i = cRows To 1 Step -1 If Cells(i, "A").Value = "" Then Cells(i, "A").Delete Shift:=xlUp End If Next End Sub But i need to delete a range from Column A to H. Thank you for your kind attention. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleted columns reset their width to zero | Excel Discussion (Misc queries) | |||
accidentally deleted two columns, can I recover them | Excel Discussion (Misc queries) | |||
Deleted Columns replaced with formatted columns | Excel Discussion (Misc queries) | |||
deleted 2 columns by mistake - what do I do | Excel Discussion (Misc queries) | |||
formulas refer to columns that are deleted | Excel Programming |