Macro to Automatically remove blank rows
 

I have an output form in a worksheet that draws selected items from
another worksheet called Master. Is there a macro that will remove any
blank rows on my output form?


--
Jack Wood
------------------------------------------------------------------------
Jack Wood's Profile: http://www.thecodecage.com/forumz/member.php?userid=346
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=100536

Macro to Automatically remove blank rows
 

Hi Jack this should do the trick:

Code:
--------------------
Dim i As Long
For i = ActiveSheet.UsedRange.Rows.Count To 1 Step -1
If Application.WorksheetFunction.CountA(Rows(i & ":" & i)) = 0 Then
Rows(i).EntireRow.Delete shift:=xlUp
End If
Next i
--------------------


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=100536

Macro to Automatically remove blank rows
 

Hi,
Look at CPearson web he has the macro with and explanation and different
scenarios

http://www.cpearson.com/excel/deleti...eleteBlankRows

if this helps please click yes, thanks

"Jack Wood" wrote:


I have an output form in a worksheet that draws selected items from
another worksheet called Master. Is there a macro that will remove any
blank rows on my output form?


--
Jack Wood
------------------------------------------------------------------------
Jack Wood's Profile: http://www.thecodecage.com/forumz/member.php?userid=346
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=100536

Macro to Automatically remove blank rows
 

It would also be helpful if you didn't multi post then those of us who freely
give time to help didn't wate that time answering question you already have
an answer to!!

Mike

"Jack Wood" wrote:


I have an output form in a worksheet that draws selected items from
another worksheet called Master. Is there a macro that will remove any
blank rows on my output form?


--
Jack Wood
------------------------------------------------------------------------
Jack Wood's Profile: http://www.thecodecage.com/forumz/member.php?userid=346
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=100536

Macro to Automatically remove blank rows
 

Post in only one forum


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=100536