VBA equivalent to Excel's mod function

excel excel-2007 vba
Arlen Beiler picture Arlen Beiler · Dec 7, 2010 · Viewed 216.9k times · Source

Is there a vba equivalent to excel's mod function?

Answer

Vincent Ramdhanie picture Vincent Ramdhanie · Dec 7, 2010

In vba the function is MOD. e.g

 5 MOD 2

Here is a useful link.

Related questions

How to do a "Save As" in vba code, saving my current Excel workbook with datestamp?

I have an Excel Workbook that on form button click I want to save a copy of the workbook with the filename being the current date. I keep trying the the following ActiveWorkbook.SaveAs ("\\filePath\FormFlow To MSExcel\" & Left(…

Read More
Closing Excel Application using VBA

I have used the following without success. The active workbook closes, indeed, but the excel window remains open. Application.ActiveWindow.Close SaveChanges:=False ActiveWorkbook.Close SaveChanges:=False Which is the command that terminates the application? EDIT To say a little …

Read More
Excel Date Conversion from yyyymmdd to mm/dd/yyyy

I have been searching for about an hour on how to do this in Excel. I have an Excel file that was created from an old system and I am pulling information from a SQL Server Database, I will be …

Read More