| - Selva V Pasupathy , Hyderabad, India |
| - Selva V Pasupathy , Hyderabad, India |
220. How to Get Prime Numbers or Factors A prime number is any integer that can be divided evenly only by itself and one. A factor of a number is an integer that can be evenly divided into that number. This article contains Microsoft Visual Basic for Appl ications macros for Excel that… KB#246802. Keywords: VBA, Macro, Web
221. Function to Convert Degrees/Minutes/Seconds Angles to or from Decimal Angles Angular measurements are commonly expressed in units of degrees, minutes, and seconds (DMS). One degree equals 60 minutes, and one minute equals 60 seconds. To simplify some mathematical calculations you may want to express angular measurements… KB#213449. Keywords: Format, Formulas, VBA, Web
222. Swap as in Swap Columns or Swap Rows This page contains some VBA macros. If you need assistance to install or to use a macro please refer to Getting Started with Macros. For more depth see Install a Macro or User Defined Function on my Formula page. Speed and efficiency considerations can be seen in Proper, and other Text changes and… Keywords: Formulas, VBA, Macro, User Defined Function, Web, Comments
223. Automation AddIn Function Binds to Excel BuiltIn Function with the Same Name When you create an Automation Add-in that is targeted for Microsoft Excel and you insert a function from your add-in into an Excel worksheet by using the Insert Function dia log box, Excel binds to the built-in function instead of your custom… KB#286305. Keywords: Add-In, DLL, Errors, Formulas, VBA
224. How to Use the ApplyCustomType Method to Format Charts When you run a Microsoft Visual Basic for Applications macro in Microsoft Excel 97, you can use the ApplyCustomType method to apply standard or custom chart types to a chart or a series in a char t. This article explains how to use the… KB#167279. Keywords: Charts, SERIES, Format, Errors, Macro, Object, VBA, Error Message, Toolbar, Web
225. Function That Uses the ActiveCell Property Returns Incorrect Result When you enter a formula that calls a custom function, the formula may return an incorrect result when you recalculate the worksheet. The formula returns the correct result only when you select the cell that contains the formula and then… KB#213684. Keywords: Formulas, VBA, Object, Web
226. How to Programmatically Save a Worksheet as HTML An updated version of the Internet Assistant Wizard for Microsoft Excel 97 is available. This updated wizard allows you to export a worksheet to a Hypertext Markup Language (HTML) file by using a Visua l Basic for Applications macro. NOTE: The… KB#168561. Keywords: Add-In, Charts, Download, Export, Arrays, VBA, Macro, Files, HTML, Web
227. Visual Basic Editor (VBE) Window Project Explorer (ctrl+R) displays a hierarchical list of the projects and all of the items contained and referenced by each project. I have no idea of what options below came with installation, or if anything was cha nged, and if changed for the better or not. This is what I have…. Keywords: Colors, Fonts, Errors, Class, Object, VBA, VBE, Files, Registry, Text Files, Web, Comments, Window
228. Gantt chart on a worksheet MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a parti cular purpose. The Visual Basic procedures on this web site are provided “as… Keywords: Charts, GANTT, Dates, Years, Borders, Colors, Conditional Formating, Patterns, Formulas, VBA, Web
229. Excel – a VBA function to extract text If you import a text file of data into an Excel worksheet you may wish to extract a particular range of characters from each record. For example if each data record (or row) looks something like ‘A100 John 23.5 South’ you may wish to extract the number (23.5) which is the third out of four items in… Keywords: SERIES, Format, Formulas, VBA, Macro, User Defined Function, Text Files, Parse, MID, FIND, VALUE
