Forum

Create a function t...
 
Notifications
Clear all

Create a function that May derive a number Excerpt from '1-90 Possibilmentenon Repetitive

3 Posts
2 Users
0 Reactions
51 Views
(@a-maurizio)
Posts: 214
Reputable Member
Topic starter
 

Hello everyone my name A.Maurizio I am writing because my problem and this.
Would I Know how to create a Routin I can Highlight the cell (A1) of the first Excel sheet with Office 2007.
including a number from 1 to 90 possibly non-repetitive Thanks

 
Posted : 27/12/2016 11:01 am
(@db325)
Posts: 19
Active Member
 

Perhaps something like the following:

Sub Test()

Worksheets(1).Cells(1, 1).Interior.ColorIndex = 43

Worksheets(1).Cells(1, 1) = Int((90 - 1 + 1) * Rnd + 1)

End Sub

 
Posted : 27/12/2016 12:31 pm
(@a-maurizio)
Posts: 214
Reputable Member
Topic starter
 

 Hello Derek Brown Thanks for Your Beautiful and Functional Help.
And in His Really Simple Together, but extremely effective Thanks.
Unless you feel like I do have some time, you can download this My Jobs from this link:

https://app.box.com/s/nud50w7sg7yfj35fafnut60kb2cwbdic

and then after it is viewed in all its parts, give me your opinion, for me it would be very important, Thanks
And Happy Holidays to you and family.
Greetings from A.Maurizio

 
Posted : 28/12/2016 5:07 am
Share: