A cell that counts the number of times...
I'm trying to create a formula for a cell on a worksheet that automatically counts the number of times a value (ANY VALUE) in a particular cell has been entered. Is this possible?
SO basically,..if ANYTHING is entered into this one cell,..it triggers this other cell to count that as 1. It tells me that the cell was populated.
I'm a newbie in Excel, so any help is greatly appreciated.
Last edited by TPD; 02-14-2005 at 03:37 PM.
Todd P. Dolce
Try with this code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column = 1 And Target.Row = 1 Then 'observed cell is (1,1) - A1
Cells(1, 5) = Cells(1, 5).Value + 1 'Counter is in cell (1,5) - E1
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1