Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Currently I have a sheet which contains data in columns A-Q, I have added
some code in WorkSheet_Change to track any changes in the existing data, this same code is currently telling me that a newly entered row of data has been changed which is technically correct but I'd rather have it tell me that the row is a new row rather than changed. Code I'm using is: Private Sub Worksheet_Change(ByVal Target As Range) Dim iRow As Integer If Not Intersect(Target, Range("A:Q")) Is Nothing Then iRow = Target.Row Cells(iRow, 19).Value = "Changed!" End If End Sub Currently this puts "Changed!" in column S, if any new code means using yet another column that would be okay too. It would be cool if it remained in the same column though. Ideas or suggestions? Thanks, Larry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rows to drop off (hide) when a value is entered into a cell | Excel Discussion (Misc queries) | |||
Can I rearrange data entered in rows into colums in Excel? | Excel Discussion (Misc queries) | |||
Excel will not show all text entered in a Cell merged from 9 rows | Excel Discussion (Misc queries) | |||
Why won't my newly entered data sort with old data ? | Excel Discussion (Misc queries) | |||
Why won't my newly entered data sort with old data ? | Excel Discussion (Misc queries) |