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

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

Or sort your data by this column. All the #n/a's will be together and you can
delete them in one fell swoop.

Or maybe...
Select the column with the errors
Edit|goto|special|Formulas or Constants|Errors
Edit|Delete|Entire row

If you have errors that you want to keep (#ref/div0, ...), then don't use this.

dmoney wrote:

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

--

Dave Peterson