5. When the SomeSubroutine sub is run, which cell of the spreadsheet will have the word "Hello" in it? Only enter a lett

[answerhappygod]

5 When The Somesubroutine Sub Is Run Which Cell Of The Spreadsheet Will Have The Word Hello In It Only Enter A Lett 1 (144.54 KiB) Viewed 35 times

5. When the SomeSubroutine sub is run, which cell of the spreadsheet will have the word "Hello" in it? Only enter a letter followed by a number, no spaces and no other text, when you submit your answer. Option Explicit Sub SomeSubroutine () Dim A () As Variant, k As Integer Dim i As Integer, j As Integer k = 1 ReDim A(k) As Variant A(0) = Worksheet Function.RandBetween(1, 10) A (1) "Hello" For i 1 To 4 A = Some Function (A, k) k = k + 1 ReDim Preserve A(k) As Variant A(k) Worksheet Function.RandBetween(1, 10) Next i Range ("A1:A" & k + 1) = Worksheet Function. Transpose (A) End Sub = Function Some Function (A As Variant, k As Integer) As Variant Dim i As Integer, B() As Variant ReDim B (k) As Variant For i = 0 To kl B(i) = A(k - i) Next i Some Function = B End Function Enter answer here