I want to delete all values starting from
LOWER , i.e.
A B C .... O P Q
I am not sure how to do this
How do I explain that I need the range of
"A2:0 infinity "
Perhaps something like this would work for you:
Sub RemoveValues() ActiveSheet.Range(ActiveSheet.Range("A2:O2").Address, ActiveSheet.Cells(Rows.Count, 1).Address).ClearContents End Sub
This will remove all content from cells
A2:O2 and downward.