| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove LOTS of blank rows at once | Excel Discussion (Misc queries) | |||
| gang remove blank rows | Excel Discussion (Misc queries) | |||
| Remove Blank and Non Data Rows | Excel Discussion (Misc queries) | |||
| remove or hide blank rows | Excel Discussion (Misc queries) | |||
| How do I remove blank rows in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
