Thread
:
moving a "count" range
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
moving a "count" range
One possible Formula if a simple count(K:K)won't do
=COUNT(INDIRECT("K1:K"&MATCH(9999,K:K)))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"sramsey" wrote in message
...
I'm creating a macro where my count() range changes by 1 everyday. For
example, on day 1, my count range would be =count(a1:a30). On day 2 my
range
would be =count(a2:a31), day 3 would be (a3:a32) and so on. So far I
think
it may look something like:
Range("J20").Select
ActiveCell.FormulaR1C1 = "=COUNT(R[9]C[2]:R[13]C[2])"
Range("J21").Select
only much better, with a +1 in there somewhere...
Any ideas?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett