I'm trying to overwrite formulas with their values in my range (B8:Z200). My range contains hidden columns and Excel will not allow me to copy paste values using visible cells only (error: This action won't work on multiple selections). The only way is to copy paste values over each visible column one at a time. As I am not familiar with looping, is there a code to do this? Any help would be appreciated. Thanks.