FormulaArray dragging formulas down

[norseman1]

Hello all-

So I am working on a macro for my office that project managers can use to keep track how many hours employees are assigned and look at upcoming deadlines. The part that I am having trouble with is the organization of these deadlines. I want the deadlines to ultimately be organized in a 'Calendar View,' and I believe that I am on the brink of writing a code that accomplishes this. I am very new to VBA, so this code is undoubtedly pretty sloppy. The specific part of the code that I am having trouble with is the dragging down of my FormulaArray, as it is not doing what I want it to do. Here is this specific part of my code and what the code produces:

Please Login or Register  to view this content.

formulaarray error.JPG

This is not what I am looking for....I am looking for something like this, where the formula is dragged down.

formulaaray correct after saveas.JPG

Interestingly enough, the second image is the exact image I get from my code if I SAVE the Excel Doc. If I SAVE the document, the output is exactly what I want.

Why is this? Any help on my code, or how to get the FormulaArray to drag down and produce what I want without having to SAVE AS would be greatly appreciated!

Ignore the formatting, I'll tidy it up if/when I fix these bugs!

Thank you

-norse

[TMS]

Sounds as though you might have set calculation to manual and not set it back to automatic.

[norseman1]

You were exactly right.....I didn't even know that was a thing. Thank you TMS!

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.