Filter that column on #N/A and delete all visible rows. You can record the
code to do it.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"dmoney" wrote in message
...
I am currently using an if iserror statement to loop through and delete
rows
that have returned a #n/a error as a result of a pivot table. I am
looking
for a more efficient way to perform this operation. I am working with
over
20k rows of data and looping through one cell at a time is really slow.
Any
help would be appreciated.

Thanks in advance,
Devin