Compile error user defined type not define

Hi, Mukesh,

the data should have gone to OClumn Z when the code was written, right now it´s going over to Column AF. So basicly the answer is yes but I would avoid any hardcoding on the Columns and use the last used Column in Row 8 like

With Sheets("Personal")
  x = .Range(.Cells(8, "O"), .Cells(.Cells(Rows.Count, "p").End(xlUp).Row + 1, .Cells(8, Columns.Count).End(xlToLeft).Column)).Value
End With

But that won´t solve the problem of the email addresses not being included in the range you read into x.

Ciao,
Holger