View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DMoney DMoney is offline
external usenet poster
 
Posts: 130
Default Pound NA problem

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