Splitting my data

I'm having some issues with actually implementing the macro. the only thing that happens when i run it is the cursor changes to the loading symbol (for most it's a blue circle continuously rotating) and excel becomes unresponsive. i've waited several minutes before going into task manager and it was still unresponsive and displaying the loading cursor symbol. any ideas what the issue is? i've noticed that it says compatability mode on the window bar above not sure what that means though. also it is excel 2007 so idk


Edit: i'm not sure if this would be a factor but each cell is 1rowX1column and there are 1000 rows with 90 columns each but 5-15 blank columns per row. 90,000 cells in total including blanks. should that cause it to take longer than the 10 minutes i waited before using task manager?