-
Newest Blog Post
-
Recent Posts
- Tom’s Tutorials For Excel: Getting Unique Items From a List
- Tom’s Tutorials For Excel: What time is it *Really*? Ask the US Navy With a Web Query
- Tom’s Tutorials For Excel: Locating Your PivotTable’s Occupied Range
- Tom’s Tutorials For Excel Videos: Explaining Array Formulas
- Tom’s Tips For Excel: Using an InputBox and Looping Dates for Copy and Sum
Recent Comments
- Tom Urtis on Tom’s Tutorials For Excel Videos: Explaining Array Formulas
- Brady on Tom’s Tutorials For Excel Videos: Explaining Array Formulas
- Tom Urtis on Tom’s Tutorials For Excel: Sorting Birthdays, Excluding the Year
- Joseph on Tom’s Tutorials For Excel: Sorting Birthdays, Excluding the Year
- Tom Urtis on Tom’s Tutorials For Excel: Getting Unique Items From a List
Archives
Akismet Spam Counter
Total Spam Fought: 20,273
Monthly Archives: December 2011
Tom’s Tutorials For Excel: Specifying UserForm Position on Screen
Tom’s Tutorials For Excel: Specifying UserForm Position on Screen You can automatically position your UserForm almost anywhere on your screen, with the following Initialize event code that goes into the UserForm’s module. Example 1, upper left Private Sub UserForm_Initialize() Me.StartUpPosition … 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: Comparing Two Lists and Formatting Differences
Tom’s Tutorials For Excel: Comparing Two Lists and Formatting Differences Here’s how you can format differences in a long list when comparing it to a shorter list. In the picture, column A holds a comprehensive list of names, and column … Continue reading
Tagged 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: Using a Comment to Log Changes in a Cell
Tom’s Tutorials For Excel: Using a Comment to Log Changes in a Cell Here’s an easy way to keep a running log of changes to a cell’s text. Suppose you want your employees to enter an explanation or description of … 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: Set Page Breaks For Specified Areas
Tom’s Tutorials For Excel: Set Page Breaks For Specified Areas If your worksheet has areas of data that you want to print on separate pages, you can easily establish page breaks based on a wide choice of cell properties or … 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
Tom’s Tutorials For Excel: Keep a Running Count of Duplicate Entries
Tom’s Tutorials For Excel: Keep a Running Count of Duplicate Entries In cases where duplicate entries are expected, you can easily keep a running count of each entry with a formula to tell you how many times the entry exists … 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: VBA Help — Usually Right, Sometimes Wrong
Tom’s Tutorials For Excel: VBA Help — Usually Right, Sometimes Wrong The above picture shows a simple macro that calls a Message Box to display a tab name by referring to the active sheet’s CodeName property. Suppose you’ve never before … 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, Microsoft Office 2010, Tom Urtis, Tom Urtis/ Atlas on facebook, Tom's Tutorials for Excel
2 Comments
Sad Loss in the Excel and Technical Community
Sad Loss in the Excel and Technical Community I’m writing this blog tonight with a heavy heart, as I just learned that Excel MVP and personal friend Nate Oliver has suddenly passed away. For those of you who did not … Continue reading
Tom’s Tutorials For Excel: Blinking Cells and Flashing Objects
Tom’s Tutorials For Excel: Blinking Cells and Flashing Objects Free and safe downloadable workbook with blink examples With VBA, you can make cells or their contents look as if they are blinking or flashing. This is not a popular tactic … 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: Automatically Show UPPER Case Text In Cells
Automatically Show UPPER Case Text In Cells If you want to make sure that text entries in lower case — even alphanumeric entries — will automatically be displayed in UPPER case as soon as the entry is made, here’s how … Continue reading
Tagged @TomUrtis/Atlas on Twitter, atlas, Atlas Program Management, Atlas programing management, Atlas Programming on Facebook, Automatically Show UPPER Case Text In Cells, 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
