Filtering with spaces between rows

Closed
diestra123 Posts 10 Registration date Monday October 22, 2012 Status Member Last seen July 15, 2013 - Apr 4, 2013 at 08:05 AM
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 - Apr 4, 2013 at 10:46 AM
Hi All,
Is there a way I can filter my column if there are spaces between rows? the spaces were put there for neat presentation purposes. :(

thanks in advance for your help.

1 reply

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Apr 4, 2013 at 10:35 AM
Hi Diestra123,

I don't think Excel has that functionality.
A workaround could be to create double entries, where the text color of the duplicate is turned white. This way it looks like an empty row, but Excel is still able to filter.

Best regards,
Trowa
0
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Apr 4, 2013 at 10:46 AM
Here is a code that might be helpfull in creating the above:

Sub CreateDub()
Dim x As Integer
Dim sCol As String
sCol = "H" 'Adjust Column letter to match your data.
x = 2 'Data starts at row 2, if not change the number.
Do
Range(sCol & x).Copy Range(sCol & x + 1)
Range(sCol & x + 1).Font.ColorIndex = 2
x = x + 2
Loop Until Range(sCol & x).Value = vbNullString
End Sub
0