G
Guest
I am trying to use some kind of offset to clearcontents of a range of cells
I have Names in Column A but they are not listed one other the other. Some
have more rows between them the the others. I need to be able to clear the
contents of the rows based on what is in column A.
Kinda like:
Sub ClearQAScoresPage()
Dim rng As Range
Sheets("Sheet1").Select
Set myrng = Worksheets("Sheet1").Range("A:A")
For Each c In myrng
If c.Value <> "" Then
Clear the cells.................??????/
myrng.ClearContents
End If
Next
End Sub
How do I select the cells based on an offset.
I have Names in Column A but they are not listed one other the other. Some
have more rows between them the the others. I need to be able to clear the
contents of the rows based on what is in column A.
Kinda like:
Sub ClearQAScoresPage()
Dim rng As Range
Sheets("Sheet1").Select
Set myrng = Worksheets("Sheet1").Range("A:A")
For Each c In myrng
If c.Value <> "" Then
Clear the cells.................??????/
myrng.ClearContents
End If
Next
End Sub
How do I select the cells based on an offset.