View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tonso Tonso is offline
external usenet poster
 
Posts: 90
Default macro to set bottom and top values for randbetween

I want to select a cell or a range of cells, then fill it with randbetween numbers. The bottom and top values will vary from time to time. How can I accomplish this. Maybe have an input box appear where the user could enter the bottom/top values, or designate 2 cells where the user could input the values, invoke the macro, and have it refer to those 2 cells to get the bottom/top values?

Thanks!

Tonso