Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SEARCH EXCEL ARRAY FOR NON-VOIDS AND ENTER INTO ANOTHER ARRAY,
I HAVE A WOORKSHEET THAT HAS WHOLE ROWS WITH SPACES IN BETWEEN SOME ROWS WITH
DATA. ON ANOTHER WOORSHEET I WANT TO JUST HAVE THOSE ROWS THAT CONTAIN DATA. THE ORIGINAL CANNOT CHANGE. THANKS. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SEARCH EXCEL ARRAY FOR NON-VOIDS AND ENTER INTO ANOTHER ARRAY,
Run the following code.Th eassumption is that if a cell in column A is empty,
then the entire row can be deleted... Option Explicit Sub RemoveBlankRows() Dim col As Range Set col = Range("A:A") Set col = col.SpecialCells(xlCellTypeBlanks) If Not col Is Nothing Then col.EntireRow.Delete End If End Sub Patrick Molloy Microsoft Excel MVP "ROSE THE RED" wrote: I HAVE A WOORKSHEET THAT HAS WHOLE ROWS WITH SPACES IN BETWEEN SOME ROWS WITH DATA. ON ANOTHER WOORSHEET I WANT TO JUST HAVE THOSE ROWS THAT CONTAIN DATA. THE ORIGINAL CANNOT CHANGE. THANKS. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I can't enter an array in Excel 2007 | Excel Discussion (Misc queries) | |||
I can't enter an array in Excel 2007 | Excel Worksheet Functions | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
How do I resize a named array in Excel from a MxN array to a mxn . | Excel Programming | |||
Loading Excel Array from VB Array Faster | Excel Programming |