resize rows and column
Hi,
I am not sure if this is the answer of your query.
Sub TestMyArray()
'Declare array
'But, remember to start it from 1
'So, do not start it from 0
Dim FinalOutput(1 To 2, 1 To 4) As Integer
FinalOutput(1, 1) = 100
FinalOutput(1, 2) = 200
FinalOutput(1, 3) = 300
FinalOutput(1, 4) = 400
FinalOutput(2, 1) = 170
FinalOutput(2, 2) = 270
FinalOutput(2, 3) = 370
FinalOutput(2, 4) = 470
'Call array and paste
Range("b2").Resize(2, 4) = FinalOutput
End Sub
Hope it works.
Regards,
Noor Faiz
"newbie" wrote:
hi
how do i resize rows and column so that i can see the whole data in the cell
without doing it manually? i'm using visual basic .net
|