Results 1 to 19 of 19

Assign value to a name in VBA

Threaded View

  1. #1
    Registered User
    Join Date
    09-13-2010
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    88

    Lightbulb Assign value to a name in VBA

    Dear All,
    I used below to assign a value to a name in VBA but, VBA said there is an error 1004 as" application defined or object defined error".

    ThisWorkbook.Names("Rvalue").refertorange.Value = MyValue
    Any suggestions? Where can I find some document about using Names in VBA?

    Thanks.

    Regards,
    SpringLily
    Last edited by SpringLily; 09-22-2010 at 04:54 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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