Wow That is neat. Thanks I need to try and remmember that.
On Thursday, July 26, 2012 12:56:39 AM UTC-4, अनिल नारायण गवली wrote:
> Dear Tony,
>
> U can use without macro
> Just select the range and press ctl+G of press F5 function key .
> Then click to blank cell and use Alt+E+D select the
Aid Software
dguille...@gmail.com
From: Tony O
Sent: Wednesday, July 25, 2012 6:43 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel VBA to loop through rows and delete blank lines
I am working on a spreadsheet with Excel 2007.
I have the vba code to delete a line:
Selection.
can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
____________________
From: Tony O
To: excel-macros@googlegroups.com
Sent: Wed, July 25, 2012 7:46:33 PM
Subject: $$Excel-Macros$$ Excel VBA to loop through rows and delete blank lines
Dear Tony,
U can use without macro
Just select the range and press ctl+G of press F5 function key .
Then click to blank cell and use Alt+E+D select the row and delete it
Regards,
Gawli anil
On Thu, Jul 26, 2012 at 8:42 AM, NOORAIN ANSARI wrote:
> Dear Tony,
>
> Please try it..
>
> *Sub Dele
Dear Tony,
Please try it..
*Sub DeleteBlank()*
*On Error Resume Next
ActiveSheet.UsedRange.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
On Error GoTo 0: On Error GoTo -1: Err.Clear*
*End Sub*
On Thu, Jul 26, 2012 at 5:13 AM, Tony O wrote:
> I am working on a spreadsheet with Ex
I am working on a spreadsheet with Excel 2007.
I have the vba code to delete a line:
Selection.Delete Shift:=xlUp
I want to delete all rows that have the cells in column A that are blank
and column B and column C for just those rows.
I'm thinking that the code should look something like this,