Thread
:
Deleting a row
View Single Post
#
5
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Deleting a row
try
Sub RowBeGone()
Columns("c").SpecialCells(xlCellTypeBlanks).Entire Row.Delete
End Sub
--
Don Guillett
SalesAid Software
"Neal" wrote in message
...
How would I write the code to delete a row depending on if a certain cell
is
blank?
If e1 is blank delete row 1 and so on.
range("C").Select
do
row.Delete Shift:=xlUp
loop until isempty(activecell<" ")
Or something like this? I would greatly appreciate the help. Thanks Neal.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett