Runtime Error 1004

Hi,

i am currenlty working on what I thought was a pritty simple Excel do. for work. i have added in some macro's etc. for some buttons and have been using a very basic code to get the job done fast. Here is some of the code:

Please Login or Register  to view this content.

I am getting the error on the "Split Busbar" line. it is in reffernece to a work sheet of which I cannot simply change the name. The only thing that I can think of is that the space between the two words is causing an issue??? Any ideas??!!!