+ Reply to Thread
Results 1 to 2 of 2

Cell = Workbook name code?

  1. #1
    Registered User
    Join Date
    12-02-2020
    Location
    France
    MS-Off Ver
    2016
    Posts
    8

    Cell = Workbook name code?

    Hi all,

    I have named my Workbook an ingredient name i.e. APPLE. I would like to be able to reference APPLE into a cell. How can I do this with VBA?

    It feels simple enough, but I haven't been able to find much information online...

    Thanks for your help in advance!

    Kind regards,

    Lou

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,051

    Re: Cell = Workbook name code?

    If you want book name
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Can I use vba code to get a value of a cell in other workbook without opening the workbook
    By mrkhchan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2015, 11:50 PM
  2. [SOLVED] Code to cut cell from one workbook, close same workbook, and paste in different workbook
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 03-13-2014, 04:01 PM
  3. [SOLVED] Macro to Use Multiple Cells in Workbook to Create Code Cell in another Workbook
    By michaelpair in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-26-2013, 10:33 AM
  4. [SOLVED] A code that will copy a cell and put i in a workbook
    By Excelmanineedhelp in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-08-2012, 11:28 AM
  5. VBA Code: Activate Workbook Using Cell Value
    By vidyuthrajesh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-17-2012, 12:55 PM
  6. vba code for setting the cell value to be equal to cell value in another workbook
    By yellowpower in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2010, 04:10 AM
  7. Code to open a workbook , copy info and return it to another workbook using a cell v.
    By england79m in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2008, 11:22 AM

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