VBA // How to fill blank in those cells who have #n/a and like as string

[riya]

Hi All,
Please help me out on the attached file. I have to convert #n/a and string value to "" from VBA.

INPUT 50 60 USD
0 0
60 USD
#N/A #N/A
60 CNY 60 CNY
80
60 MSY 60 MSY
0 0
66 66
76 USD 84 MSY
84 MSY

OUTPUT 50
0 0



80

0 0
66 66

 

[vletm]

riya
one sample for that
... press [ Do It ]

 

[riya]

riya
one sample for that
... press [ Do It ]

Hi Vletm, You have provided the code. this code runs in all rows and column. but suppose i want to start from column 6 or 7 that mean no need to change in data till column 5. how it is possible.

 

[riya]

riya
one sample for that
... press [ Do It ]

Sorry, Please ignore last reply, i have done it by change the column no. Thanks alot