PDA

View Full Version : VBA : Populate list



dek
04-21-2009, 10:18 AM
Hi,

Problem:
Require to create a list of "global outlook contacts" in Column A for given "inhouse staff member" in Column B.

I cannot figure out how to loop through each "global outlook contact" and assign to an "inhouse staff member".

See attachment.

Bob Phillips
04-21-2009, 10:31 AM
Sub Example()
Dim aryNames
Dim i As Long

aryNames = Split(Range("AE3"), ";")
For i = LBound(aryNames) To UBound(aryNames)

MsgBox (aryNames(i))
Next i
End Sub