Jump to content

Need Some Excel Vba Help


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

  • Create New...