Calculating short term and long term moving average in VBA

maybe "Cells" instead of "Cell"

I just have one more problem.

My module doesn't run as the name "Sub MovingAverage" can't be defined as noted on the compile error that pops up.

Pl see the attached edited macro.

Please Login or Register  to view this content.

I'm having difficulties with the VBA programming, just wondering if someone could give a basic example of how to set up a mortgage loan calculator using VBA?
Cheers.