1 Visitor Messages

  1. tejista
    As you will see from this post I am a relative beginner programming in VBA. I need to to generate a random number between 2 numbers, so I am using
    ActiveCell.FormulaR1C1 = "=RANDBETWEEN(2, k)"
    I use "k" because that number has been inputed by the user in an InputBox message. Apparently it will not generate a random number. Whenever I change "k" for an actual integer, the program does work. Thanks
Showing Visitor Messages 1 to 1 of 1
About tejista

Basic Information


About tejista
Location:
Slippery Rock, PA, USA
My Microsoft Office Version:
Excel 2003

Statistics


Total Posts
Total Posts
1
Posts Per Day
0.01
Last Post
RANDBETWEEN Does Not Accept a letter variable 02-03-2012 03:32 PM
Visitor Messages
Total Messages
1
Most Recent Message
02-03-2012 10:47 AM
General Information
Last Activity
02-03-2012 03:34 PM
Join Date
02-03-2012

Search Engine Friendly URLs by vBSEO 3.2.0