I think I'm working with number values of 0, not text, not sure if that matters. This is changing blank cells to N/A, not just 0 cells to N/A. It's been filling in all the blank spaces in my sheet with N/A lol The program runs till it gets to a cell that already has an error (#ref) and then stops working. If you know a way to bypass the #ref cells and continue that'd be great, or a way to only change the 0 values, not the blank ones I'd really really appreciate it. Thank you so much for helping me, I'm really quite useless when it comes to VBA