Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Folks!
I use this formula extensively for testing: =ROUND(RAND()*100,0) That simply generates random 2 digit integers. What I would like is a macro that will insert that formula into the selected range then do the equivalent of CopyPaste SpecialValues. It doesn't necessarily have to "insert that formula" just so the macro generates random 2 digit ints in the selected range. I use this so often it makes sense to have a macro that I can attach to a toolbar button. Thanks! Biff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using a formula in a macro | Excel Discussion (Misc queries) | |||
Formula or Macro | Excel Discussion (Misc queries) | |||
Need formula or Macro Help | Excel Worksheet Functions | |||
Macro Formula for Max value | Excel Worksheet Functions | |||
formula to a macro help PLEASE | Excel Discussion (Misc queries) |