UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Count a Change to a Cell    
 
   
RAZMaddaz
post Oct 3 2007, 03:25 PM
Post #1

UtterAccess VIP
Posts: 6,171
From: Bethesda, MD USA
Is there any function/formula that can count how many times a particular cell, which has a date in it, changes? Thanks!!!

RAZ
Go to the top of the page
 
+
NateO
post Oct 3 2007, 03:29 PM
Post #2

Remembered
Posts: 5,055
From: Minneapolis, MN, USA
You'd want a VBA Worksheet Change event, if the date is not there by Worksheet Function. See the following:

http://www.cpearson.com/excel/Events.aspx

However, if it's there by function, e.g., Today(), which is volatile, you might want to consider the Calculate event.
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 06:43 AM