Removing #N/A

[gaurav.itian]

Hi,

I have a big excel file that uses a lot for Vlookup formulas. SOem fo these are returning #N/A.

Now my problem is i have to use the output results populated in these cells for some other formulas and charts and hence i want to replace the existing #N/A 's with blanks.

I can't rebuld the excel with IF (ISNUMBER(), Vlookup, "") method. And if i try to use Control + Replace it doesnt looks for the cell value rather it looks for the formula and hence doesnt finds #N/A's.

If somebody has any idea on this then you help would be highly appreciated.

Cheers,
Gaurav

[jeminar]

you could recode everything with if(iserror(<cell>),leave blank,<cell>) as an extra column if you want it dynamic.

If you want to manually and permanently delete errors (incl. the formula behind) then I use the following code:

Please Login or Register  to view this content.

[gaurav.itian]

Hi,

Thanks for the help. Recoding everything would be humangous task as lot of cells have different search scopes in Vlookup function.

Also, i could not get your code. How do i pass input area to this macro. Can i use a button to directly run this macro and clean everytime i press the button?