TomDrury89
New Member
- Joined
- Aug 22, 2018
- Messages
- 14
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
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