Sample Visual Basic macros for working with arrays in Excel This article contains sample Microsoft Visual Basic for Applications procedures that you can use to work with several types of arrays. Microsoft provides programming examples for illustration only, without warranty either expressed or implied....
How to sum a range of cells based on a number format in Excel This article includes a sample Microsoft Visual Basic for Applications custom function that sums the values in a range of cells that are formatted with a specific custom number format. Microsoft provides programming examples for illustration only,...
Description of the Microsoft Office 2004 for Mac 11.3.6 Update Microsoft has released an update for Office 2004 for Mac. This update improves security and stability and addresses some issues with individual Office 2004 for Mac programs. A link to download this update is provided.
Date returned in a macro is four years too early When you run a macro that uses a date from a worksheet cell, the date returned by the macro may be four years and one day earlier than the actual date.
Error when you paste ActiveX Controls or run a macro in Excel for Mac When you open a workbook in Microsoft Excel for Mac and you copy and paste an ActiveX Control or run a Microsoft Visual Basic for Applications macro, you may receive one or more of the following error messages: In Excel X for Mac or a later version,...