Results 1 to 4 of 4

Runtime Error 1004

Threaded View

  1. #1
    Registered User
    Join Date
    03-29-2007
    Posts
    2

    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:

     
    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??!!!
    Last edited by VBA Noob; 03-29-2007 at 10:21 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1