RANDBETWEEN Excel Function in Macro

[igor7]

Hi there!
I need some help or advice...
I have a vb code below which generate numbers in desired cells according to the range provided in the code.

Please Login or Register  to view this content.

Code working well but when I'm clicking on the some cell from the range it show me formula (for instance: =RANDBETWEEN(45,65)) in the formula field even I've deleted the vb module.
I need that formula will not appears any more after macro finished to run and all tables will be filled with the numbers. The best solution will be possibility to delete the macro after it ran and all numbers stay as is in the desired tables.
Thank you in advance,
Igor

[alansidman]

If I understand correctly, you want the results to remain as hard coded values after the macro runs and not show up as formulas. Is this what you are looking to happen?

[naveenmarapaka]

Try to add below code after every select, this will replace formula with values..

like after your code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

or just put 1 line or code after all your code....
( select the full range)

Please Login or Register  to view this content.

[igor7]

If I understand correctly, you want the results to remain as hard coded values after the macro runs and not show up as formulas. Is this what you are looking to happen?

Yep, this is correct!

Try to add below code after every select, this will replace formula with values..

like after your code...

Just add after Selection.AutoFill.... Selection.Copy.... in each section, correct?

[naveenmarapaka]

I suggest you 2nd option.. that's would be better... put the code just before End Sub

[igor7]

Guys, thanks to both of you for replay as well as for fast and professional solution!!