Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
modifyA
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! |