Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning an array to range object?
Hi,
This seems like a silly question but I cant seem to find the answer€¦ In VBA I can do this Dim wks As Worksheet Dim rng As Range Set wks = ThisWorkbook.ActiveSheet Set rng = wks.Range("A1").Resize(1, 5) rng = Array("One", "Two", "Three", "Four", "Five") How do I do the same in VB.NET (2005)? Thank you, ~Smitch |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning an array to range object?
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning an array to range object?
Thank you for the response€¦ I should rephrase my question:
When in VB.NET using the Interop libraries how do you get the Range = Array assignment to work. I always get an cast exception. I have tried straight array as well as object array. Thank you, ~Smitch "merjet" wrote: http://www.vb-helper.com/howto_net_declare_arrays.html Hth, Merjet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
assigning array back to range | Excel Programming | |||
Assigning Range to Array | Excel Programming | |||
Assigning range to array not working | Excel Programming | |||
Assigning array to range inside Excel Object | Excel Programming | |||
Selecting cells which do not meet a formatting criteria, and assigning a Range object to these. | Excel Programming |