Note: Microsoft provides programming examples for illustration only, without warranty either expressed or implied.This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the VBA programming language, and with the tools that are used to create and to debug procedures.

Get from External Data Source. Get from Data Model. Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.. Get from Power BI. Use this option if your organization uses Power BI and you want to discover and connect to endorsed cloud datasets you have ...

Create contact lists. A contact list is a collection of email addresses, and is useful for sending email to a group of people. Contact lists are sometimes referred to as distribution lists.. For example, create a contact list named My book club and add all the members of your book club to it. When you want to send an email message to everyone in the club, just add My book club in the To line ...

Note: Microsoft is updating the way we ask for permission to use your voice data to improve Microsoft products that use our speech recognition technology.This may impact the data you see on your privacy dashboard. To learn more about these changes, see How does Microsoft protect my privacy while improving its speech recognition technology?

Tip: In Windows 7, you can synchronize your computer clock with an Internet time server to keep the computer clock up to date.To do this, select the date or time in the bottom right-hand corner of your screen, and then select Change date and time settings.Select the Internet Time tab, select Change settings, select Synchronize with an Internet time server, and then select Update now.

Note: If you are in tablet mode, desktop icons are not displayed.To see your desktop icons in tablet mode, go to Start > Settings > System > Tablet, then select Change additional tablet settings.Under When I'm using tablet mode, make sure that Hide app icons on the taskbar and Automatically hide the taskbar are both set to Off.

Argument name. Description. range (required). The group of cells you want to count. Range can contain numbers, arrays, a named range, or references that contain numbers. Blank and text values are ignored. Learn how to select ranges in a worksheet.. criteria (required). A number, expression, cell reference, or text string that determines which cells will be counted.

If you don’t want to use the proxy server when you visit certain websites, enter the ending of the website address in the exception list (for example, *.contoso.com). For multiple websites, type each website address and separate the addresses with a semicolon (for example: *.contoso.com; *.adatum.com).The * is a wildcard so any website addresses that end with the website address listed will ...

Type three of the characters shown below, and then press Enter. The line is inserted for the full width of the page. When inserted into a column, the line is inserted to match the width of the column.

Take a closer look at the macro . You can learn a little about the Visual Basic programming language by editing a macro. To edit a macro, in the Code group on the Developer tab, click Macros, select the name of the macro, and click Edit.This starts the Visual Basic Editor.