Randbetween function embedded in a macro HELP

		Microsoft Office Forums > Microsoft Excel > Excel
Randbetween function embedded in a macro HELP

FAQ

Thread Tools

Display Modes

02-21-2021, 01:51 AM

Purfleet

Windows 10 Randbetween function embedded in a macro HELP

Office 2019

Expert

Join Date: Jun 2020

Location: Essex

Posts: 345

Try something like this

Code:

Sub Randomly_generate_a_number_between_1_and_10_inclusive()
'
' Macro1 Macro

    Range("b:b").Interior.Color = xlNone
    
    randnum = WorksheetFunction.RandBetween(1, 10)
'
    Range("D2") = randnum
    
    Range("A:A").Find(what:=randnum, LookIn:=xlValues, lookat:=xlWhole).Offset(0, 1).Interior.Color = vbYellow
       
    
End Sub

Attached Files

Copy of RECAP Project_Purfleet.xlsm (23.2 KB, 6 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RANDBETWEEN question	derohanes	Excel	3	01-25-2019 09:38 AM
Calculating bonus in an embedded IF function	Yde1203	Excel Programming	2	07-22-2018 08:24 AM
RandBetween for PowerPoint	excelledsoftware	PowerPoint	1	09-19-2014 11:32 PM
RandBetween Formula Help	acbh	Excel	1	09-12-2013 06:51 PM
word macro that reformats embedded links in a doc	EricT	Word VBA	7	09-12-2012 04:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:19 AM.