VBA Order of Operations and 400 Error

[Ascension]

Hey gurus,

So I'm trying to construct the macro below and my error is coming from, I believe, the handling of the multiplication, division and possibly the pulling in of the information for the offset function. I'm looking for some input on the macro in terms of design and any clues as to how to make it work.

*The worksheet is protected and cannot be posted online.*

Macro Logic:
Until the conditions are satisfied, iterate a multiplication of a variable user input number against a variable secondary number, the primary number is in a known location, the secondary location is unknown and changes (hence the necessary offset tied to a variable range).

Thanks!

MiniCount = 0
                        While MiniCount < Variable1 + 1
                            Sheet4.Range("Name1").Offset(0, Variable2 + MiniCount).Value = _
                            Sheet4.Range("Name1").Offset(0, Variable2 + MiniCount).Value + _
                            Variable 3 * _  (Sheet2.Range("Name2").Offset(Sheet2.Range("Name3").Value, 0) / 12)
                            MiniCount = MiniCount + 1
                        Wend

[davesexcel]

*The worksheet is protected and cannot be posted online.*

Then post an example of the workbook with the code you are using....