 <p>Completely new answer as of given details. You are working with <code>VBA</code> so you can call <strong>WorksheetFunctions</strong> like</p> <pre><code>Dim someVariable someVariable = WorksheetFunction.Quotient(Worksheets("Sheet1").Cells(1, "A").Value, Worksheets("Sheet1").Cells(1, "B").Value) Debug.Print someVariable </code></pre> <p>There is a quite good list of supported functions available on <a href="http://msdn.microsoft.com/en-us/library/office/dn301180%28v=office.15%29.aspx" rel="nofollow">MSDN WorksheetFunction</a>. Please choose your current Excel version on the linked page.</p> <p>Furthermore I found another very important site concerning your problem that states that <strong>not all WorksheetFunctions are supported as Application</strong>. (see <a href="http://support.microsoft.com/kb/107564/en-GB" rel="nofollow">support.microsoft.com</a>)</p> <p>So I searched for workarounds and found a quite simple one on <a href="http://stackoverflow.com/questions/4378047/vba-equivalent-to-excels-mod-function">StackOverflow</a>. But on the other hand - you really could make use of the VBA builtIn operator <strong><a href="http://msdn.microsoft.com/de-de/library/se0w9esz.aspx" rel="nofollow">MOD</a></strong></p> <pre><code>' created some variables, as I made some attempts on creating a good example Dim value1 value1 = Worksheets("Sheet1").Cells(1, "A").Value Dim value2 value2 = Worksheets("Sheet1").Cells(1, "B").Value someVariable = value1 Mod value2 Debug.Print someVariable ' of course you may use a single line statement too someVariable = Worksheets("Tabelle1").Cells(1, "A").Value Mod Worksheets("Tabelle1").Cells(1, "B").Value </code></pre> <p>I think there are some pretty good links to have a deeper look into.</p>