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

--
Rob van Gelder - http://www.vangelder.co.nz/excel


wrote in message news:WijHd.18701$B95.6487@lakeread02...
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 -

Thanks. I'll give it a go.

....best, Hash

In article ,
"Rob van Gelder" wrote:

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