In conclusion, we can easily generate a random 10 digit number in excel by following this method.
In addition, insert the following code in the code window:ĪctiveSheet.Cells(GRN, 3) = Round((Rnd() * 9999999999# - 1) + 1, 0).The above command opens a new blank VBA code window for that worksheet.To begin with, right-click on the active sheet and select the option ‘ View Code’.To demonstrate this method we use the following dataset that we have also used earlier.įollow the below steps to perform this method. In the last method, we will generate a random 10 digit number with the use of a VBAcode. Insert VBA Code to Create 10 Digit Number in Excel Finally, we can see randomly generated 10 digit numbers in cells ( C5:C9).Ħ.Set the ‘ Output Range’ to the array’s beginning which is cell C5.Set the parameters to a range of 1 to 9999999999.In the Distribution field, we have chosen the option Uniform.
The number of rows is indicated by the ‘ Number of Random Numbers’.The ‘ Number of Variables’ field specifies how many columns we want to fill with random data.We will input values for different parameters to generate random 10 digit numbers. After that, we get one more pop-up window named ‘ Random Number Generation’.Select the ‘ Random Number Generation’ option and then click OK. Moreover, scroll down the options in the ‘ Analysis Tools’ section.
Then click “Go”.ĥ – Make sure to have the Analysis Add-In checked and click “Ok” Then click “Go”.ģ – If the Analysis Office Add-In is listed here select it and click on Enable.Ĥ – If Analysis Add-In is not listed, like in the screenshot above, go back to Step #2 and select “COM AddIn” in the Manage box.
This is very simple to solve and this post will show you how to do it.Ģ – Click on “Add-Ins” tab and select “Disabled Items” in Manage box. So you have to re-enable the Analysis Add-In in MS Excel or MS PowerPoint. In these cases, Analysis Add-In may have been disabled by the Microsoft application after some crash. Make sure that Analysis Add-In is not disabled by Office Application” “The launcher was not able to connect Analysis Add-In.You try to launch Analysis for Office and you are getting some errors like the messages below: You cannot find the Analysis Add-In tab in your MS Excel or MS Powerpoint. There is some situations where you have to manually activate the Analysis for Office Add-In.