Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Jun 21, 7:26*am, "Vacuum Sealed" wrote:
Your're right about your assumption of not making sense... Much of what I submit here makes little sense to me as everyday is a learning day for me here No need to get defensive. My comment was not meant as criticism. I was trying to point the meaning of the Count property. And on second thought, I wonder if you do not mean to use Count at all. It returns the number of cells in a range. So myRng.Count is 297 with your range of F4:F300. I wonder if you want is: For each c in myRng Range("M" & 5+Hour(c)) = Range("M" & 5+Hour(c)) + 1 Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNTIF, SUMPRODUCT, or something else | New Users to Excel | |||
sumproduct or countif | Excel Discussion (Misc queries) | |||
Countif - Sumproduct | Excel Worksheet Functions | |||
Countif or Sumproduct | Excel Worksheet Functions | |||
COUNTIF or SUMPRODUCT | Excel Discussion (Misc queries) |