Delete cells without selecting?

[Hash]

All -

I'm doing a For each ... next down column A. When I come across a cell
value I don't like I want to delete that cell and the six to the right,
shifting up. Alternatively I could delete the whole row, which I keep
track of with counter n.

Which is better? And is there a way to either it without Range("A" & n
& ":G" &n).select and then delete xlup?


Thanks in advance.

....best, Hash

 

[Rob van Gelder]

How about: Cells(n, "A").Resize(, 7).Delete xlShiftUp

 

[Hash]

Rob -

Thanks. I'll give it a go.

....best, Hash