then Copy down
Note that the ranges are of equal length/height now
Try these and modify to suit
Dim No_Cells As Long
No_Cells = InputBox("Please enter the number of cells to Sum", "Sum Range")
Dim sum_rng As Range
Set sum_rng = Range("A1:A" & CStr(No_Cells))
Dim my_sum As Double
First, I'd go away fr5om Week Numbers to dates. Why what happens to the dates like 30 August?
Second, E4: =IF(AND($C4<=F$3,$D4>E$3),$B4,"")
Third: Fix up the Month Tiles, to align with the months better
Today on July 26, 2009 the Chandoo.org Forums were turned on.
So after 10 years, 39,144 threads, 246,519 messages and with 51,201 members a big Happy Anniversary is in order
Happy 10th Anniversary Chandoo.org Forums
I look forward to the next 10
You are trying to make an Array based on Today() and a number of months ahead of that, and then lookup the value of A2 in that array
Unless they conicide it will not match
Shouldn't C2 simply be : =EDATE(A2,B2)
I would look at Peter's example and work through the data flow that you need, see where/how it is handled in Peters model
There are times where Names don't appear as simple as maybe you think it should be
But the logic of what peter Has setup is flexible and extensible in that it allows you to...
Daniel taught that Names are actually more correctly Named Formulae and that all Named Formulae are Array Formula
ie: A100 is actually a Named Formula referencing some memory that has a value or formula that you associate to a logical grid position of A100
Daniel went into great lengths in the...