+ Reply to Thread
Results 1 to 2 of 2

Referencing another cell

  1. #1
    Forum Contributor
    Join Date
    07-26-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2016 Office 365 ProPlus
    Posts
    822

    Referencing another cell

    Feel a bit silly for having to ask this but I somehow can't find the fix myself

    Say I have a formula in sheet1 cell A1.

    Now I want to get the "value" (by VBA of course...in normal excel its very simple) also lets say in sheet1 cell F11.
    But the value in A1 can differ (by use of validations), so it should be a simple formula in F11 which references to every value A1 will get.

    ps: I do not want to use the same formula as in A1 because it is a complez formula and I'm looking for the simple solution.

  2. #2
    Forum Contributor
    Join Date
    07-26-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2016 Office 365 ProPlus
    Posts
    822

    Re: Referencing another cell

    Ok after some more trial and error I found it myself....and indeed was very very simple.

    Sheet1.Range("F11").Value = "=A1"

+ 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] Cell formula referencing file path contained in separate cell not working
    By BrokenDome in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2019, 08:17 AM
  2. Help with Referencing a Cell Relative to Active Cell in Custom Function Code
    By mjjb99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2016, 09:33 PM
  3. Replies: 0
    Last Post: 01-09-2013, 06:58 AM
  4. Replies: 5
    Last Post: 12-19-2012, 09:16 AM
  5. Replies: 1
    Last Post: 10-14-2012, 12:23 AM
  6. Change Cell Font Color if Cell Contains Formula Referencing Another Cell
    By wilcox.patrick in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-10-2012, 10:24 PM
  7. Lookup referencing cell referencing range
    By cmcconnehey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-15-2008, 06:19 PM

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