Excel VBA Macros question

Need a programming geek’s help here: I’m writing a macro that starts on one sheet, does some stuff, and then moves on to another sheet and selects all the cells in that sheet. For some reason every time I run the macro it gets stuck on the step where it’s supposed to select all the cells. Anyone know wtf the problem is. Here is the code, where I drew the "

n/m, I figured out what the problem was. I was trying to add this macro to a button and it wouldn’t allow me to make changes on other sheets with a private sub so I had to reference a general sub macro instead.