Clearing Cells with Errors

[mlarson]

Hi all, I am trying to create a macro that will clear the cells (not the entire row) that contain any error (#N/A, #VALUE!, etc.). I found information on deleting the entire row but nothing when searching for how to clear only the cells.

I would like to clear the cells where errors occur in Columns N:T. Can use workbook name of "Workbook1.xlsm"

Thanks for your help.

 

[mlarson]

I play fantasy football but I have to agree with you. Far too many people now don't even have a favorite team and only care about individual players... and players don't care much about winning as they used to and now want to appease fantasy owners. With that said, if one can keep it in perspective (I still cheer for my favorite team even if it hurts my fantasy team) it is pretty fun.