LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,688
Default Formula in macro help

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a formula in a macro Al @ Frontier[_2_] Excel Discussion (Misc queries) 2 January 26th 10 04:00 PM
Formula or Macro A.S. Excel Discussion (Misc queries) 6 March 5th 08 01:16 AM
Need formula or Macro Help Atomic Excel Worksheet Functions 1 April 26th 07 05:38 PM
Macro Formula for Max value John Bundy Excel Worksheet Functions 0 November 30th 06 05:25 PM
formula to a macro help PLEASE Hemming Excel Discussion (Misc queries) 2 March 9th 06 03:16 PM


All times are GMT +1. The time now is 06:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"