Hello,
When using the weekday function, I got a message error about incompatible types:
What does this error means? How can I solve it? ThanksSub MIX_FillDays(howmanydays As Integer, ByVal monthnumber As Integer, ByVal yearnumber As Integer) Dim fullday As String Dim dayoftheweek As Integer Dim dayname As String Dim ran As String I = 1 Sheets("taks1").Select Do Until I = howmanydays fullday = I & "/" & monthnumber & "/" & yearnumber dayoftheweek = Weekday(fullday) '*** error happens here! *** Call MIX_TranslateWeekDayName(dayoftheweek, dayname) ran = "I" & I + 3 Range(ran).Value = dayname I = I + 1 Loop End Sub





Reply With Quote