Is there a way to force an Excel VBA macro to perform a quartile operation on a range that includes #N/A or blank spaces?
Any help is appreciated!
Thanks
Is there a way to force an Excel VBA macro to perform a quartile operation on a range that includes #N/A or blank spaces?
Any help is appreciated!
Thanks
I had no problem with blanks, If you're seeing #N/A then it is a formula. Change the formula to handle errors gracefully
=IF(ISERROR(OriginalFormula,"",OriginalFormula)
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ