K
kyoshirou
i am exploring this http://www.contextures.com/xlForm02.html
would like to improve further on...
I have realised if column A1, B1,C1 has been entered,
The forumula will auto got to D2,E2,F2.
Therefore, i would like to ask how do i prevent the new data goes to D2,D3,D4.
By right, it should go to D1,E1,F1.
With historyWks
With .Cells(nextRow, "AM")
.Value = Now
.NumberFormat = "mm/dd/yyyy hh:mm:ss"
End With
.Cells(nextRow, "AN").Value = Application.UserName
oCol = 4
For Each myCell In myRng.Cells
historyWks.Cells(nextRow, oCol).Value = myCell.Value
oCol = oCol + 1
Next myCell
End With
Thanks!
would like to improve further on...
I have realised if column A1, B1,C1 has been entered,
The forumula will auto got to D2,E2,F2.
Therefore, i would like to ask how do i prevent the new data goes to D2,D3,D4.
By right, it should go to D1,E1,F1.
With historyWks
With .Cells(nextRow, "AM")
.Value = Now
.NumberFormat = "mm/dd/yyyy hh:mm:ss"
End With
.Cells(nextRow, "AN").Value = Application.UserName
oCol = 4
For Each myCell In myRng.Cells
historyWks.Cells(nextRow, oCol).Value = myCell.Value
oCol = oCol + 1
Next myCell
End With
Thanks!