frank_m
12-16-2010, 11:11 AM
I'm wondering if a formula in a cell can count how many rows are above that cell, if and when the sheet calculate event if triggered.
I want to use this so that during a selection change, or calculate sheet event, I can determine if the row count in the used range has changed since the last Selection Change and/or Calculate event fired.
I was thinking that if this is possible, then I will not need a solution to my other post here on a different subject, but related:
http://www.vbaexpress.com/forum/showthread.php?t=35423
Thanks,
Frank
I want to use this so that during a selection change, or calculate sheet event, I can determine if the row count in the used range has changed since the last Selection Change and/or Calculate event fired.
I was thinking that if this is possible, then I will not need a solution to my other post here on a different subject, but related:
http://www.vbaexpress.com/forum/showthread.php?t=35423
Thanks,
Frank