Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sub Macro1()
Dim s(10, 10) As String For i = 1 To 10 For j = 1 To 10 Cells(i, j).Value = s(i, j) Next Next End Sub Use the above for a range of the same dimensions as the string array. Or use an Offset if you need it. -- Gary''s Student " wrote: Hi I have a Visual Basic program (Visual basic.NET 2005) where I automate Excel (2003). In the program, I have a two dimensional array of strings, that I need to paste into a range in Excel. How do I do it? Best regads, Lars Olsen Denmark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Let user insert value that highlights closest value in an array. | Excel Discussion (Misc queries) | |||
Syntax to insert an array formula in a cell | Excel Programming | |||
How do I always insert last cell from a increasing array ? | Excel Worksheet Functions | |||
Tricky array formula issue - Using array formula on one cell, then autofilling down a range | Excel Programming | |||
Insert Rows into an existing array | New Users to Excel |