Start Loop in "A2"

silentwolf

Well-known Member
Joined
May 14, 2008
Messages
1,087
Hi guys,

I got this code from a a gast user of a different forum. "Volker"

I did modify it a little but seam not be able to get the loop started at "A2" rather then "A1".

Code:
Sub FillDaysOfMonth()
    Dim datStart As Date
    Dim datEnd As Date
    Dim d As Date
    
    Columns(1).ClearContents
    Range("A1").Value = "Datum"
    
    datStart = DateSerial(Year(Cells(1, 5)), Month(Cells(1, 5)), 1)
    datEnd = DateSerial(Year(datStart), Month(datStart) + 1, 1) - 1
    
    For d = datStart To datEnd
        Cells(Day(d), 1) = d
    Next d
End Sub
does anyone know how I need to change this code above to make that work?

Many thanks"
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,426
Office Version
2010
Platform
Windows
Hi guys,

I got this code from a a gast user of a different forum. "Volker"

I did modify it a little but seam not be able to get the loop started at "A2" rather then "A1".

Code:
Sub FillDaysOfMonth()
    Dim datStart As Date
    Dim datEnd As Date
    Dim d As Date
    
    Columns(1).ClearContents
    Range("A1").Value = "Datum"
    
    datStart = DateSerial(Year(Cells(1, 5)), Month(Cells(1, 5)), 1)
    datEnd = DateSerial(Year(datStart), Month(datStart) + 1, 1) - 1
    
    For d = datStart To datEnd
        Cells(Day(d) [B][COLOR="#FF0000"]+ 1[/COLOR][/B], 1) = d
    Next d
End Sub
does anyone know how I need to change this code above to make that work?
Maybe adding what I show in red will do it.
 

silentwolf

Well-known Member
Joined
May 14, 2008
Messages
1,087
Hi Rick,

yes it works fine!
I tried with Cells(Day(d)1 ,1)=d
before...

hmm never stop learning :)
 

Forum statistics

Threads
1,078,442
Messages
5,340,305
Members
399,366
Latest member
ahmed elsaid

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top