Macro to look at multiple columns

[TomDrury89]

Hi,

I currently have the below macro which looks at column K and clears the blank cells. I am wondering if there is a way to then have a look at doing the same for column L and D. My macro skill is very limited.

The below macro was provided to me, i am just hoping to extend this to other columns.

Sub FilterBlank()

With ActiveSheet
With Range("K4:K" & .Cells(Rows.Count, 1).End(xlUp).Row)
.Offset(-1, 0).AutoFilter Field:=1, Criteria1:=""
.ClearContents
End With
.AutoFilterMode = False
End With
End Sub

 

[davesexcel]

Is there a reason you are clearing the contents of blank cells?

This is a good oportunity to practice using the macro recorder.

 

[Peter_SSs]

Is this really the same question as: VBA code to clear contents of all cells that look blank in a range