Have a Question?

If you have any question you can ask below or enter what you are looking for!



VBA

Please suggst how to solve the below question

1. Print any 10 numbers between 1-10 randomly  and there should be no duplicate number?


  Rupesh Kumar

Please share an example, i am unable to get you properly.

  Devbrat Tripathi       19 Jul 2016       0       0     

hi , 

for this use simple for loop .

please run below code for the same.

Sub abcd()

Dim i, k As Integer

k = 1

For i = 1 To 10

    Sheet1.Cells(i, 1) = k 

    k = k + 1

    Next i

End Sub


 



  Rakesh Sharma       25 Jul 2016       1       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any