I have some data (spanning a few hundred thousand rows) in column A, such as:
Day
Monday
Tuesday
Friday
ClsData:
Option Explicit
Private pDayOfWeek As String
Private pFruit As String
Public Property Get DayOfWeek() As String
DayOfWeek = pDayOfWeek
End Property...