Problems # Status Problem 1 Excel-VBA : Range - Lock/Unlock Specific Cells 2 VBA-Excel: Date-Time Functions - Timer() 3 VBA-Excel: Date-Time Functions – TimeSerial() and TimeValue() 4 VBA-Excel: Date-Time Functions – WeekDay() and WeekDayName() 5 VBA-Excel: Date-Time Functions – Month(), Year() and MonthName() 6 VBA-Excel: Get all the WeekDays or Working days in Specified Date Range, (excluding Satudays and Sundays) 7 VBA-Excel: Date-Time Functions – Hour(), Minute(), Second() 8 VBA-Excel: Date-Time Functions – FormatDateTime() 9 VBA-Excel: Date-Time Functions – Day() 10 VBA-Excel: Date-Time Functions – DateValue() 11 VBA-Excel: Date-Time Functions – DateSerial() 12 VBA-Excel: Date-Time Functions – DatePart() 13 VBA-Excel: Date-Time Functions – DateDiff() 14 VBA-Excel: Date-Time Functions – DateAdd() 15 VBA-Excel: Date-Time Functions – IsDate() 16 VBA-Excel: Date-Time Functions – CDate() 17 VBA-Excel: Date-Time Functions – Date(), Now() and Time() 18 VBA-Excel: Array Functions – Filter() 19 VBA-Excel: Array Functions – Join() – Converts Array to String 20 VBA-Excel: Array Functions – IsArray() 21 VBA-Excel: Array Functions – LBound and UBound() 22 VBA-Excel: Create Array using Array() Function 23 VBA-Excel: Fill Excel Range Values in a 2D Array 24 VBA-Excel: Array Functions – Split() 25 VBA-Excel: Arrays – Multi Dimensional Array 26 VBA-Excel: Arrays – Two Dimension, Dynamic Array 27 VBA-Excel: Arrays – Two Dimensional, Static Array 28 VBA-Excel: Arrays – One Dimension, Dynamic Array 29 VBA-Excel: Arrays – One Dimension, Static Array 30 VBA-Excel: String Functions – String() 31 VBA-Excel: String Functions – strComp() 32 VBA-Excel: String Functions – Space() 33 VBA-Excel: String Functions – Replace() 34 VBA-Excel: String Functions – Mid() 35 VBA-Excel: String Functions – Len() Excel-VBA : Range - Lock/Unlock Specific Cells VBA-Excel: Date-Time Functions - Timer() VBA-Excel: Date-Time Functions – TimeSerial() and TimeValue() VBA-Excel: Date-Time Functions – WeekDay() and WeekDayName() VBA-Excel: Date-Time Functions – Month(), Year() and MonthName() VBA-Excel: Get all the WeekDays or Working days in Specified Date Range, (excluding Satudays and Sundays) VBA-Excel: Date-Time Functions – Hour(), Minute(), Second() VBA-Excel: Date-Time Functions – FormatDateTime() VBA-Excel: Date-Time Functions – Day() VBA-Excel: Date-Time Functions – DateValue() VBA-Excel: Date-Time Functions – DateSerial() VBA-Excel: Date-Time Functions – DatePart() VBA-Excel: Date-Time Functions – DateDiff() VBA-Excel: Date-Time Functions – DateAdd() VBA-Excel: Date-Time Functions – IsDate() VBA-Excel: Date-Time Functions – CDate() VBA-Excel: Date-Time Functions – Date(), Now() and Time() VBA-Excel: Array Functions – Filter() VBA-Excel: Array Functions – Join() – Converts Array to String VBA-Excel: Array Functions – IsArray() VBA-Excel: Array Functions – LBound and UBound() VBA-Excel: Create Array using Array() Function VBA-Excel: Fill Excel Range Values in a 2D Array VBA-Excel: Array Functions – Split() VBA-Excel: Arrays – Multi Dimensional Array VBA-Excel: Arrays – Two Dimension, Dynamic Array VBA-Excel: Arrays – Two Dimensional, Static Array VBA-Excel: Arrays – One Dimension, Dynamic Array VBA-Excel: Arrays – One Dimension, Static Array VBA-Excel: String Functions – String() VBA-Excel: String Functions – strComp() VBA-Excel: String Functions – Space() VBA-Excel: String Functions – Replace() VBA-Excel: String Functions – Mid() VBA-Excel: String Functions – Len() 1 2