I am writing data onto a table that I am building, but my data keeps on "writing over" the previous data and won't start a new row instead. I have this built so far.
With ScheduleOverview 'Now we need to state where we want the first lines of deliverable to start Dim Row As Long Dim WorkOrderColumn As Integer Dim DeliverableDatesColumn As Integer Row = 17 WorkOrderColumn = 5 DeliverableActivityColumn = 12 DeliverableDatesColumn = 13 Debug.Print workOrder Cells(Row, WorkOrderColumn).Value = workOrder Cells(Row, DeliverableActivityColumn).Value = DeliverableCodes Cells(Row, DeliverableDatesColumn).Value = DeliverableDate 'Go to next row Row = Row + 1 End With https://stackoverflow.com/questions/65767619/having-trouble-going-to-the-next-row January 18, 2021 at 09:04AM
没有评论:
发表评论