Posts by luana • 67 points
4 posts
-
0
votes1
answer722
viewsQ: how do I sum all the numbers in each row and column?
I am trying to sum up all the numbers of each row and column. I tried to do as below, but it is not working. ranger .ClearContents For n = 1 To 10 For Z = 1 To 10 Cells(Z, n) = Int(100 * Rnd()) k =…
-
0
votes1
answer546
viewsQ: number even, odd, zero and more than 10 how to find?
For g = 1 To 10 For f = 1 To 10 Cells(f, g) = Int(100 * Rnd()) k = Cells(f, g) If Int(k / 2) - k / 2 = 0 Then pares = pares + 1 Else Impares = Impares + 1 End If If k = 0 Then Zeros = Zeros + 1 If k…
-
3
votes1
answer1216
viewsQ: Separate Even, Odd and Equal values in Matrix by VBA (Excel)
how to make a 10x10 matrix, separate pairs and odd and equal without using Mod ?…
-
0
votes2
answers4700
viewsQ: How to find out if a number is odd or even?
How to find odd and odd pairs from this list? Sub kati() For li = 1 To 10 For col = 1 To 10