I have a macro that I found and I need to make some changes. However, I'm not that familiar with VBA so I need some help.
What I need it to do is select range A1 end right and range end down. Maybe like this : "If Range("A1", Range("A1").End(xlDown).End(xlToRight)).Select
I don't know how to put it in the code below.
Goal is to take all the 0 and blank cells and clear them.
Sub Clear_Content()
If VarType(Range("B1")) = vbEmpty Then
Range("A1").ClearContents
ElseIf VarType(Range("B1")) = vbString Then
If Len(Range("B1")) = 0 Then
Range("A1").ClearContents
End If
End If
End Sub
Bookmarks