-
Newest Blog Post
-
Recent Posts
- Tom’s Tutorials For Excel: Copying Multiple ListBox Selections to Worksheet
- Tom’s Tutorials For Excel: Summing to Today’s Date With INDIRECT
- Tom’s Tutorials For Excel: SUMIF For Days Past Last Date
- Tom’s Tutorials For Excel: Horizontal SUMPRODUCT
- Tom’s Tutorials For Excel: Formatting Numbers and Text With Custom Colors
Recent Comments
- Tom Urtis on Tom’s Tutorials For Excel: The INDIRECT Function
- Biray Kocak on Tom’s Tutorials For Excel: The INDIRECT Function
- Tom Urtis on Tom’s Tutorials For Excel: Reading the Registry for Your Email Client
- Jon Peltier on Tom’s Tutorials For Excel: Reading the Registry for Your Email Client
- Tom Urtis on Tom’s Tutorials For Excel: Updating Links (or Not)
Archives
Akismet Spam Counter
Total Spam Fought: 9,958
Monthly Archives: November 2011
Tom’s Tutorials for Excel: Auto-Sort By Double-Clicking a Cell
Tom’s Tutorials for Excel: Auto-Sort By Double-Clicking a Cell This example toggles a sort in ascending and descending order for a table of data whose headers are in row 1. When you double-click any cell in the data range, the … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Auto-Sort By Double_Clicking a Cell, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: Open a Workbook To a Specific Sheet and Cell
Tom’s Tutorials For Excel: Open a Workbook To a Specific Sheet and Cell How can you open a workbook to a specific worksheet and cell? For example, regardless of where you were in the workbook when it was last closed, … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: How to Show Your Workbook’s Name in a Cell
Tom’s Tutorials For Excel: How to Show Your Workbook’s Name in a Cell Here are a few ways to show your workbook’s name in a cell, example, YourWorkbookName.xls. Formula (goes on one line but broken into 2 lines for browser … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: Name your sheet tab same as cell value.
Name your sheet tab same as cell value. You can rename a worksheet in real time the moment you change a cell’s value. A Worksheet_Change event can look at the entry, evaluate it for worthiness, and immediately rename the worksheet … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, Excel VBA 24-Hour Trainer, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
2 Comments
Tom’s Tutorials For Excel: Does a Worksheet Exist, and Create One if Not?
Tom’s Tutorials For Excel: Does a Worksheet Exist, and Create One if Not? There are three scenarios usually associated with this question. Scenario #1: Simply yes or no, does a certain worksheet name exist in the active workbook? Sub TestSheetYesNo() … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: Validate TextBoxes for Numbers Only
Tom’s Tutorials For Excel: Validate TextBoxes for Numbers Only Here’s an example of controlling what a user enters into a TextBox on your userform, in this case, allowing only five whole numbers to be entered. Suppose you are collecting mailing … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: Delete a Table in Access From Excel
Tom’s Tutorials For Excel: Delete a Table in Access From Excel Sometimes you use Excel to manipulate other Office applications such as Word, PowerPoint, and Access. This macro shows how to connect to an Access database and delete a particular … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Delete a Table in Access From Excel, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
2 Comments
Tom’s Tutorials For Excel: Count Your Workbook’s Total Printable Pages
Tom’s Tutorials For Excel: Count Your Workbook’s Total Printable Pages Ever want to know how many total pages would print from all your workbook’s worksheets? This macro will tell you: Sub GetPrintablePageCount() Dim iSheet%, iCountStart%, iCountEnd% iCountStart = 0: iCountEnd … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Tom’s Tutorials For Excel: *Really* Clear the Clipboard
Tom’s Tutorials For Excel: *Really* Clear the Clipboard The Windows Clipboard is a temporary storage area for information that you have copied or moved from one place and plan to use somewhere else. You cannot see or touch the Clipboard … Continue reading
Tagged @TomUrtis/Atlas on Twitter, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Excel, excel how to, frequently asked questions about Excel, innovative use of Excel, Microsoft Excel, Microsoft MVP, Microsoft Office, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
VETERAN’S DAY
VETERAN’S DAY I am proud of my Veteran Dad. Here, photos from the memorable time I took my parents to the World War II Memorial 7 years ago from today, the first Veteran’s Day it was open.
