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:
Sub Select2()
Range("20kV!F16").Value = 2
End Sub
Sub Select3b()
Range("Split Busbar!F16").Value = 2
End Sub
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??!!!
Bookmarks