+ Reply to Thread
Results 1 to 4 of 4

Static Randbetween

  1. #1
    Registered User
    Join Date
    01-15-2017
    Location
    LONDON, ENGLAND
    MS-Off Ver
    Excel Mac 2011 14.6.6
    Posts
    55

    Static Randbetween

    Hi

    I'm trying to generate a random integer between (2,12) - like the roll of two dice.

    I need a way to stop the Randbetween formula from refreshing when I am entering data into non related cells.

    I found this vba function that proclaims to do it but I can't get it to work.

    Please Login or Register  to view this content.
    Then entering into a cell:

    Please Login or Register  to view this content.

    Any idea what I'm doing wrong? Or does anybody have an alternate way of doing this?

    Thanks

  2. #2
    Registered User
    Join Date
    01-15-2017
    Location
    LONDON, ENGLAND
    MS-Off Ver
    Excel Mac 2011 14.6.6
    Posts
    55

    Re: Static Randbetween

    So, the second after I posted that, I figured it out.

    This is the function:

    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,514

    Re: Static Randbetween

    Should be
    Please Login or Register  to view this content.
    Edit..
    Was other way around... anyway.
    Last edited by jindon; 01-15-2017 at 08:29 AM.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Static Randbetween

    You could use this sheet change event macro

    Please Login or Register  to view this content.
    To generate a new random number hit the F9 key.
    To return to automatic calc. select the RandBetween cell, hit F2 and Enter
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Replies: 10
    Last Post: 07-03-2015, 04:29 PM
  2. Replies: 1
    Last Post: 08-12-2013, 08:38 AM
  3. Replies: 2
    Last Post: 08-12-2013, 06:19 AM
  4. randbetween
    By Blake 7 in forum Excel General
    Replies: 4
    Last Post: 10-05-2012, 09:37 AM
  5. Excel 2007 : Randbetween
    By Iandislikesformulas in forum Excel General
    Replies: 4
    Last Post: 08-31-2010, 08:42 PM
  6. Static left hand side column and static header row.. how?
    By glic in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-20-2007, 01:45 AM
  7. "Static" Behavior without Static Defn
    By Steve Drenker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2006, 09:35 PM

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