I am using a dictionary to populate key and array of elements.
Example d. Add "Jan", "2,3,29"

ws.Range("B2:D2").Resize(d.count, 1).value = WorksheetFunction.Transpose(d.Items)

I want to populate the three array elements in B2, C2 and D2; B3, C3 and D3 so on...

When I use the above mentioned code.
Only B2 column is populated with 2,3,29; whereas C2 and D2 are empty. How do I specify that array elements are comma separated and needs to be populated in range of B2:D2?

Thanks,
Vdojo

Hi

In VB you need to have this as three Add statements (http://msdn.microsoft.com/en-us/libr...(v=vs.84).aspx)

Try if it works for you

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)