resize rows and column

[Guest]

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

 

[Guest]

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

 

[ton teuns]

Use the Autofit method
Activesheet.Columns.Autofit
Activesheet.Rows.Autofit

With kind regards,
Ton Teuns