Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
resize rows and column
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
resize rows and column
Use the Autofit method
Activesheet.Columns.Autofit Activesheet.Rows.Autofit With kind regards, Ton Teuns *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting rows to resize workspace | Excel Discussion (Misc queries) | |||
How do I resize a worksheet that's stuck on 65,000 rows? | Excel Worksheet Functions | |||
lock column size for some rows and resize for other rows. | Excel Discussion (Misc queries) | |||
How do I resize a worksheet after deleting rows? | Excel Discussion (Misc queries) | |||
How can I resize columns and rows to inches? | Excel Discussion (Misc queries) |