Need urgent help from VBA God Masters

[choid]

Hi guys, I just started my internship at a data mining company and i'm trying to record a macro.

What I did was to insert 2 columns so that I could make a free extra space. Then I split data in column G into 2 separate cells if it had "_" or empty space in the data cell.
Then I used find and replace function to get the correct names that I needed to make a pivot table.

The problem is that I'm seeing a runtime error like this.

Runtime error 1004- No data was selected to parse​

There was this big yellow chunk in the debug dialog and I can't see what's going on even though I'm a cs student. I need help from excel masters and geniuses. Anything would help.!

 

[Alex Blakenburg]

I split data in column G

Your text says you are splitting column G but your macro is splitting column F.
My guess is that F7 is empty and that there is nothing below that either so that the whole selection used for the split is empty.