Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording a range of changed cells.
I have some sheets that I need to note if any of the columns within a given
row has been changed. To clarify columns A1:Q1 have data which can be changed, I'd like to have cell Srow# set to True if anyone of the items in column A-Q have been changed. I added this code below: Private Sub Worksheet_Change(ByVal Target As Range) Dim iRow As Integer iRow = Target.Row Cells(iRow, 19).Value = True End Sub This works great, execpt for one thing, I can never delete the True value cause this code intercepts that as a change. Is there a way to monitor only columns A-Q? Hope this makes sense. TIA Larry |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording a range of changed cells.
if not intersect(target,range("A:Q")) is nothing then
Perform what you want ENd if "Larry Cooke" wrote: I have some sheets that I need to note if any of the columns within a given row has been changed. To clarify columns A1:Q1 have data which can be changed, I'd like to have cell Srow# set to True if anyone of the items in column A-Q have been changed. I added this code below: Private Sub Worksheet_Change(ByVal Target As Range) Dim iRow As Integer iRow = Target.Row Cells(iRow, 19).Value = True End Sub This works great, execpt for one thing, I can never delete the True value cause this code intercepts that as a change. Is there a way to monitor only columns A-Q? Hope this makes sense. TIA Larry |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording a range of changed cells.
Thank you very much Barb, it's working like a charm now.
Larry "Barb Reinhardt" wrote: if not intersect(target,range("A:Q")) is nothing then Perform what you want ENd if "Larry Cooke" wrote: I have some sheets that I need to note if any of the columns within a given row has been changed. To clarify columns A1:Q1 have data which can be changed, I'd like to have cell Srow# set to True if anyone of the items in column A-Q have been changed. I added this code below: Private Sub Worksheet_Change(ByVal Target As Range) Dim iRow As Integer iRow = Target.Row Cells(iRow, 19).Value = True End Sub This works great, execpt for one thing, I can never delete the True value cause this code intercepts that as a change. Is there a way to monitor only columns A-Q? Hope this makes sense. TIA Larry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recording changed cells in the same sheet | Excel Discussion (Misc queries) | |||
How do I make the Stop Recording bar pop up when recording macros | Excel Worksheet Functions | |||
Retrieve individual cells from a range changed between a range | Excel Programming | |||
How do I have a macro format cells while recording? | Excel Worksheet Functions | |||
Trace all the changed cells range... | Excel Programming |