Results 1 to 2 of 2

Thread: Trouble when using the weekday function

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #2
    change it to:
    I = 1
    Sheets("taks1").Select
    Do Until I = howmanydays
        ' fullday = I & "/" & monthnumber & "/" & yearnumber
        dayoftheweek = Weekday(DateSerial(yearnumber, monthnumber, i)         
        ' Weekday(fullday) '*** error happens here! ***
        Call MIX_TranslateWeekDayName(dayoftheweek,dayname)
        ran = "I" & I + 3
        Range(ran).Value = dayname
    I = I + 1
    Loop
    Last edited by Aussiebear; 05-04-2025 at 12:08 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •