2021年1月17日星期日

Having trouble going to the next row

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

没有评论:

发表评论