Home > Excel Help Portal > Programming Excel

<<  (Page 13)  Previous              Next  (Page 15)  >>

Programming Excel

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses ways to program
Microsoft Excel using VBA.

651. How to Find Open Programs That Are DDECapable In Microsoft Excel, you can discover which of your currently open programs are capable of dynamic data exchange (DDE) by using the DDEInitiate method in a Microsoft Visual Basic for Applications macro. You can display a DDE dialog box that lists... KB#213508. Keywords: DDE, VBA, Macro, Web

 
652. "Insert Picture" Dialog Box Defaults to Thumbnails View When you try to insert a picture by using any of the programs listed at the beginning of this article, the Insert Picture dialog box always defaults to Thumbnails... KB#301459. Keywords: VBA, Macro, Web, T

 
653. Pivot table pre-process macro Fr. Mark from Kansas sent in this week's question: Pivot tables work best when the data is broken down into the most records possible, but this is not always the most intuitive way to load the data. For example, it is intuitive to load data like figure 1, but the best way to analyze the data is... Keywords: Format, PivotTables, VBA, Macro, Web

 
654. Error Creating OLE Automation Object with Microsoft Excel When you use the CreateObject function or the GetObject function in a procedure to create or return a Microsoft Excel OLE Automation object, you may receive one of the following error messages. In Microsoft Excel 97: Run-time error '429':... KB#129252. Keywords: ActiveX, OLE, Errors, Class, Object, VBA, Error Message, Web

 
655. How to Determine If a Variable Is an Array In Microsoft Excel, you can use the IsArray function to test a variable that has been set in a Microsoft Visual Basic for Applications procedure to determine whether it is an... KB#213282. Keywords: Arrays, VBA, Web

 
656. How to Programmatically Convert Column Position Numbers to Column Letters In Microsoft Excel you can create a Microsoft Visual Basic for Applications Sub procedure (macro) that uses the Column property to return the column position, and then converts the column position number to the column... KB#213264. Keywords: VBA, Macro, Web

 
657. How to Programmatically Suppress an Error Value Returned by a Formula Microsoft Excel returns an error value for any cell that contains a formula that cannot be properly calculated. These error values include the following: #DIV/0! #N/A #NAME? #NULL! #NUM! #REF! #VALUE! This article describes a Microsoft Visual... KB#213387. Keywords: Errors, Formulas, VBA, Macro, Web

 
658. Macro to Open the Most Recently Used File In Microsoft Excel 2000, if you click to select the Recently used file list check box (on the General tab of the Options dialog box on the Tools menu), the files that you used most recently are listed on the File menu. This article contains a... KB#213758. Keywords: Errors, VBA, Macro, Error Message, File Name, Files, Web

 
659. How to Determine If the Active Cell Contains a Comment This article discusses ways to programmatically determine whether a cell contains a comment and discusses compatibility issues with earlier versions of Microsoft... KB#259292. Keywords: VBA, Macro, Object, Web, Comments

 
660. How to Call Microsoft Excel Macros That Take Parameters Using Automation, you can manipulate Microsoft Excel. It is possible to call macro procedures that are stored in Microsoft Excel Workbooks by using the Run method of the Microsoft Excel Application object. Microsoft Excel macro procedures that... KB#153307. Keywords: Years, VBA, Macro, Object

 
661. How to Send a Range of Cells in EMail by Using VBA In Microsoft Excel, you can send a section of a workbook as an e-mail message. This article contains sample Microsoft Visual Basic for Applications (VBA) code that demonstrates how to automate sending a range of cells in an e-mail... KB#816644. Keywords: VBA, Web

 
662. Use custom number formatting to reduce fractions Do you remember sitting through Mr. Irwin's math class in 7th grade? That was where I learned about reducing fractions. You would be given an evil fraction like 135/864 and you would have to figure that it was really 5/32. And then there were the nasty compound fractions - where you would have to... Keywords: Conditional Formating, Custom Number Formats, Formulas, Class, VBA, Web

 
663. Visual Basic Macro to Determine if Selected Cell Is in a Specified Defined Range You can use Microsoft Visual Basic for Applications to determine if the cell that you just selected is in a specified... KB#259137. Keywords: VBA, Macro, Web

 
664. How to Scroll Window Views from Object to Object By using Microsoft Visual Basic for Applications code, you can scroll from object to object on a sheet without changing the current cell selection. The ActiveWindow methods, ScrollColumn and ScrollRow, control the position of the current Window... KB#147190. Keywords: Errors, VBA, Macro, Object, Web, Window

 
665. How to Run a WordBasic Macro from an MS Excel Macro In Microsoft Excel for Windows, you can create a Microsoft Excel macro that uses either dynamic data exchange (DDE) or OLE Automation with Microsoft Word to run a WordBasic Macro. The purpose of this article is to demonstrate, by example, how to run... KB#128405. Keywords: DDE, OLE, VBA, Macro, Object, Web

 
666. How to Count Cells That Contain Formulas, Text, or Numbers In Microsoft Excel, you can count the number of cells in a worksheet that contain formulas, text, or numbers, by using the Go To Special dialog box to select the cells and then running a macro that counts the number of selected... KB#213507. Keywords: Errors, Formulas, Command Button, VBA, Macro, Object, Web

 
667. In Cell Column Chart A reader from the Czech Republic asked about creating an in-cell chart to illustrate a percentage. If the value in a cell was 37%, he wanted to fill 37% of the cell from the bottom with a color. MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either... Keywords: Charts, Colors, Errors, VBA, Web

 
668. Sample Macro to Insert/Delete Rows or Columns on Multiple Sheets This article contains a sample Microsoft Visual Basic for Applications macro ( Sub procedure) that you can use to insert or delete rows or columns in multiple worksheets in Microsoft... KB#291305. Keywords: VBA, Macro, Object, Web, Window

 
669. How to Programmatically Format Names of Months in AllCapital Letters In the built-in date format in Microsoft Excel, only the first letter of the month is uppercase. You can create a Microsoft Visual Basic for Applications macro that can be used to capitalize the entire month... KB#213503. Keywords: Months, Format, VBA, Macro, Object, Web

 
670. Running an Excel Macro from a Command Button on the Spreadsheet You've written the perfect macro using Excel VBA. Rather than having to remember a shortcut key, you would like to add a button to the worksheet to invoke the macro. MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied,... Keywords: AutoShapes, ActiveX, Fonts, Format, Command Button, Macro, VBA, Toolbar, Web

 
671. RunTime Error 91 with Macro That Searches for Fill Color When you run a Microsoft Visual Basic for Applications macro that searches for a cell that contains a specific fill color in Microsoft Excel, you may receive an error message similar to the following: Run-time error '91': Object variable or With... KB#282153. Keywords: Colors, Format, Patterns, Errors, Macro, Object, VBA, Error Message, Web

 
672. How to Programmatically Select the Current Data Area Without Selecting the First Row In Microsoft Excel, you can create a Microsoft Visual Basic for Applications macro that selects the current data area without selecting the first... KB#213333. Keywords: AutoFilter, VBA, Macro, Web

 
673. "Runtime Error 1004" When You Attempt to Use Text to Speech in Macro When you attempt to use the Text to Speech feature in a macro, you receive an error message similar to the following: Run-time error '1004': Application-defined or object-defined... KB#277808. Keywords: Errors, Speech, VBA, Macro, Object, Error Message, Web

 
674. How to Change the Date or Time Format in a Header or Footer In Microsoft Excel 2000, when you use the date code (&D) to enter the date in the header or footer of a document, the date appears in the default MM/DD/YY format. The time code (&T) defaults to the H:MM AM/PM format. These date and time formats... KB#213510. Keywords: Format, VBA, Macro, Setup, Web

 
675. How to Create a Startup Screen with a UserForm In Microsoft Excel 97, you can use a custom UserForm and a Visual Basic for Applications macro to create a startup screen (splash screen). This article describes how to create a custom splash screen for a specific... KB#158848. Keywords: Startup, VBA, Macro, Object, UserForm, Web

 
676. File Opens Very Slowly When you open or close a workbook in Microsoft Excel, the operation may take longer than... KB#299372. Keywords: ActiveX, Errors, VBA, Object, Files, Web

 
677. How to Determine If a Workbook or a Worksheet Is Protected This article provides Visual Basic for Applications sample macros that determine whether a workbook or a worksheet is... KB#161245. Keywords: VBA, Web

 
678. Changing Numbers to Text Is there any way to get the formats to take without edit, replacing? Or is there a way to edit, replace without changing a specific cell. I've tried blanks & spaces, but it says that nothing is found.Yes, there are a lot of ways around this. The first approach is to simply change your VLOOKUP... Keywords: Format, Formulas, VBA, Web, VLOOKUP, VALUE

 
679. Macros to Loop Through Range and Act Based on Cell Value This article contains two sample Microsoft Visual Basic for Applications macros ( Sub procedures) that loop through a range of cells and determine whether each cell in the range meets certain... KB#213805. Keywords: Criteria, Colors, VBA, Object, Web

 
680. Excel Hall of Fame Kudos to Ivan F. Moala, our first Hall of Fame winner for his solution to the color banding problem. The Question: In order to help visually locate the active cell pointer, is there a way to have a temporary color band appear in the current row and column?... Keywords: Colors, Conditional Formating, Errors, VBA, Web

 
681. Macro to Import a Text File into an Existing Worksheet Microsoft Excel 2000 does not provide a direct means for importing a text file into an existing worksheet. Generally, this is done by opening the text file into its own workbook and then copying the data from the new workbook to the... KB#213816. Keywords: VBA, Macro, Object, Text Files, Web

 
682. Macro to Place Filenames in Given Directory on Worksheet The sample macros in this article place the names of all specified file types (specified by file name extension, for example .XLS) for a specified directory into a column on a... KB#74493. Keywords: Add-In, VBA, Macro, File Name, Files, Web

 
683. How to Use a Custom Dialog Box as a Startup Screen In Microsoft Excel, it is possible to use a custom dialog box and a Visual Basic, Applications Edition, procedure together to create a startup (or splash)... KB#136222. Keywords: Startup, VBA, Macro

 
684. How to Count Blank Cells in a Specified Range In Microsoft Excel, you can use a Microsoft Visual Basic for Applications macro (Sub procedure) to count the blank cells in a specified range. NOTE: You can also use the COUNTBLANK worksheet function to return the number of blank cells in a... KB#139573. Keywords: VBA, Macro, Object, Web, COUNTBLANK

 
685. How to Sort Sheets in a Workbook Although there is no built-in tool to alphanumerically sort sheets, charts, Microsoft Excel 4.0 macro sheets, and dialog sheets in a workbook, you can do this with a macro. Note In Excel 97, Excel 2000 and Excel 2002, you cannot sort modules... KB#812386. Keywords: Sorting, Macro, VBA, Web

 
686. How to Put Folder Contents into a Worksheet This article describes how to a create a Microsoft Visual Basic for Applications macro that prints the contents of a folder (directory) to a range of cells in a... KB#213343. Keywords: Printing, VBA, Macro, Files, Web

 
687. Sample Visual Basic Procedure to Print Range of Cells This article contains a Microsoft Visual Basic for Applications macro that lets you print different parts of a worksheet without first having to select the range of cells or set the print area in the Page Setup dialog... KB#213451. Keywords: Errors, Page Setup, Printing, VBA, Macro, Web

 
688. Updating Distribution Lists Linda sent in today's question: One of my Outlook contacts is incorrectly set to send e-mail to the wrong address. I can change it, but the mail sent to the MyTeam distribution list still goes to the old address. Why?Interesting problem. I wonder why Microsoft does not update the distribution lists... Keywords: VBA, Web, Window

 
689. For Each Loop to Determine If an Excel Workbook Is Open Microsoft Excel does not include a Microsoft Visual Basic for Applications function to determine whether a workbook is already open. The following sample user-defined function loops through all of the opened workbooks in memory to determine whether... KB#213299. Keywords: VBA, Web

 
690. How to Post to the New Board 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 particular purpose. The Visual Basic procedures on this web site are provided "as... Keywords: Sorting, Years, VBA, Hyperlinks, Web

 
691. How to Count Rows Displayed After Data Has Been Filtered This article contains a sample Microsoft Visual Basic for Applications Sub procedure (macro) that counts the number of rows that remain after you use AutoFilter or Advanced Filter on the Data menu to filter a... KB#213330. Keywords: Advanced Filter, AutoFilter, VBA, Macro, Web

 
692. Add a Trendline to an Excel Chart to Forecast Results Many know how to use Excel to chart existing data. It is also possible to have Excel automatically add a trend line to show the slope of data points. In this chart, I've been using Ron Martin's Weight Loss Tracker for 3 weeks. The green line is actual data and the straight black line is where I... Keywords: Charts, SERIES, Trend line, Days, Colors, Format, Styles, VBA, Web

 
693. How to Determine If a Workbook or a Worksheet Is Protected This article provides Visual Basic for Applications sample macros that determine whether a workbook or a worksheet is... KB#213761. Keywords: VBA, Web

 
694. Resizing and Moving Charts in VBA You can always record a macro to find out how to do something. Select a chart, then record a macro while you move it and resize it. The result is something like... Keywords: Charts, VBA, Macro, Object

 
695. Count Occurences of a Digit There were perhaps 6 columns (in the test file), each having from 3 to fifteen five-digit numbers. At the end of the test file, I found a new "wrinkle that I chose to ignore. It called for totals by... Keywords: Formulas, Links, VBA

 
696. How to Create a Startup Screen with a UserForm In Microsoft Excel 2000, you can use a custom UserForm and a Visual Basic for Applications macro to create a startup screen (splash screen). This article describes how to create a custom splash screen for a specific... KB#213774. Keywords: Startup, VBA, Macro, UserForm, Web

 
697. How to Add MS Excel 5.0 Dialog Sheet to a Workbook This article describes how to add a Microsoft Excel version 5.0 Dialog sheet to your... KB#154930. Keywords: ActiveX, VBA, UserForm, Web

 
698. Naming a Worksheet as the value of a target cell Use this... Keywords: Add-In, Errors, Formulas, Links, Macro, VBA, Web, INDIRECT

 
699. Office 2000 ODBC Driver Vulnerability Security Update In the course of producing the solution to the Office 97 ODBC Driver Vulnerability, Microsoft testing became aware of a separate vulnerability in the ODBC database driver that may affect Office 2000 users. This vulnerability is related to the... KB#240159. Keywords: Query, Download, VBA, Files, Web

 
700. Use Microsoft Small Business Financial Manager Every once in a while, something comes along which is so amazing, it warrants a spot in the tip of the week. I was amazed today to learn that the fine folks in Redmond had packaged an incredibly useful tool in Office 2000 Premium. The tool searched for and located my Quickbooks data. It imported... Keywords: Add-In, Charts, Dates, Ratio, VBA, Web

 

<< (Page 13)  Previous              Next  (Page 15) >>