+ Reply to Thread
Results 1 to 7 of 7

Refreshing/triggering a cell?

  1. #1
    Forum Contributor
    Join Date
    08-17-2010
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    127

    Question Refreshing/triggering a cell?

    ="=ROUNDUP("&"50.42"&",0)"

    I take this paste text only to get:

    =ROUNDUP(50.42,0)

    this wont work normally until i open the cell and press enter.

    Any way I could do that for more than 1 cell at a time?

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,680

    Re: Refreshing/triggering a cell?

    I am unable to understand what you are trying to do

    What is the use of & symbol in your formula?

    Please explain


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,634

    Re: Refreshing/triggering a cell?

    are they in any sequence?
    in 1 column?
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  4. #4
    Forum Contributor
    Join Date
    08-17-2010
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    127

    Re: Refreshing/triggering a cell?

    I am crafting the formula with other formulas... The problem is when i paste text only, and get with the final formula it won't trigger.

    Just try it.

    Copy the first thing in my first post. and paste text only.
    Now you get a formula.
    How do i get that to work other than opening a cell and pressing Enter.

    P.S.

    Quote Originally Posted by humdingaling View Post
    are they in any sequence?
    in 1 column?
    Ye they are usually in columns.
    Last edited by Polymorpher; 06-13-2014 at 03:16 AM.

  5. #5
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,634

    Re: Refreshing/triggering a cell?

    if they align in one column
    you can text to column>finish and all the cells should update

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,680

    Re: Refreshing/triggering a cell?

    Seems like you are using the new function introduced in 2013 (i.e.) FormulaText() which will get the formula used in another cell.

    So Copy pasting the arrived formula will put the formula as text. Pressing F2 and enter will convert the Text formula to act as a formula.

    Am I right?

    If so select the range (Only one Column Range) Press Alt+D+E and Press Next and Press Next and Click Finish

  7. #7
    Forum Contributor
    Join Date
    08-17-2010
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    127

    Re: Refreshing/triggering a cell?

    cool, between that and transponse I think I'll be ok.

    You'd think just changing the cell format would get it to trigger.

    Thank you.
    Last edited by Polymorpher; 06-13-2014 at 03:29 AM.

+ 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] Triggering code when leaving a cell.
    By jimblob21 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-18-2012, 03:32 PM
  2. Cell Value Change triggering UserForm
    By danygiguere23 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2012, 10:38 PM
  3. Triggering Alerts based on Cell Values
    By AppSupportKarl in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-25-2011, 09:25 AM
  4. Triggering Macro 1 time only on change of cell value
    By yidrasil in forum Excel General
    Replies: 2
    Last Post: 03-08-2008, 02:43 PM
  5. Triggering an event from a cell
    By krabople in forum Excel General
    Replies: 4
    Last Post: 12-08-2006, 04:27 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