Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a few 50x10 ranges which contain alphanumeric comments added by
the user. At init, some comments may be programmatically put in those ranges and the user is free to add/edit/clear the ranges. Is there a way to detect which ranges have changed? Exactly what cell has changed or what value has changed is not important; identifying that a change has occurred or that a comment has been cleared will suffice. I can store the initial comments in a duplicate range some place and iterate cell-by-cell in VBA to compare but this may not be the best way, so thought I'd ask. I'm assuming if a range is cleared, CountA probably is the quickest way to detect this. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Referencing Named Ranges | Excel Worksheet Functions | |||
Named Ranges | Excel Worksheet Functions | |||
dynamically building references to named ranges | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |