Jump to content

Need Some Excel Vba Help


ShakeWell
 Share

Recommended Posts

I'm working on this spread sheet, wrote a macro that outputs data onto a results sheet. Due to the nature of the macro, certain cells would come out with the value "#N/A".

 

What I would like to know is if there's a way to add some code to the macro that would check a range of cells on that sheet, and clear the contents of all cells that has "#N/A".

 

Thanks in advance.

 

Oh, this is what i tried:

 

Dim iO, iP As Integer

 

Edited by ShakeWell

Share this post


Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share

×
×
  • Create New...