-
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: December 2011
Happy New Year From Our House To Yours!
Happy New Year From Our House To Yours! Happy New Year to all our friends in the Excel and global technology family! Here at Atlas, 2011 was crazy-busy from start to finish, and we’d have it no other way! It … 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
Leave a comment
Tom’s Tutorials For Excel: Populating a ComboBox For a Range of Years
Tom’s Tutorials For Excel: Populating a ComboBox For a Range of Years This populates a UserForm ComboBox with years that start 10 years ago and end 10 years from now. The idea is to reasonably control the available year which … 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: Refreshing All Your PivotTables at Once
Tom’s Tutorials For Excel: Refreshing All Your PivotTables at Once Here are two macros you can use for refreshing all the pivot tables on your active worksheet, or all the pivot tables in the entire worbook. Sub RefreshAllActiveSheet() Dim Pt … 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 Refreshing Your Pivot Table
Tom’s Tutorials For Excel: Automatically Refreshing Your Pivot Table If you’d appreciate the convenience of having your pivot table automatically refresh whenever you change its source data, here’s how you can accomplish that. In the Before picture, the source data’s … 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: Stamping Your Worksheet Changes With Date and Time
Tom’s Tutorials For Excel: Stamping Your Worksheet Changes With Date and Time Suppose your worksheet requires frequent entries in a column, and you want to automatically record the date and time of whenever a cell in that column changes. In … 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
A Christmas Eve Celebration for Hardcore College Football Bowl Fans
A Celebration for Hardcore College Football Bowl Fans I’m a huge college football fan. On the cusp of what is celebrated as Christmas Eve by many people worldwide, I’m taking a break from Excel to mark the annual Hawaii Bowl … Continue reading
Tom’s Tutorials For Excel: Converting All Formula Cell References From Relative to Absolute
Tom’s Tutorials For Excel: Converting All Formula Cell References From Relative to Absolute When you have a lot of formulas on a worksheet for which you want to convert all cell and range references from relative to absolute, this macro … 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: Maximizing Your UserForm to Full Screen Size
Tom’s Tutorials For Excel: Maximizing Your UserForm to Full Screen Size To fill the screen with your UserForm while maintaining the relative position of the form’s controls, stick this Initialize event code into the UserForm’s module: Private Sub UserForm_Initialize() With … 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/ Atlas on facebook, Tom's Tutorials for Excel
Leave a comment
Happy Hanukkah !
Happy Hanukkah! It’s a festive season everywhere! Tonight is the first night of Hanukkah for my Jewish friends. This canine pal & I say [or woof] L’Chaim! to all …Tom
Tom’s Tutorials For Excel: Preventing Save or Close Unless Cells are Filled
Tom’s Tutorials For Excel: Preventing Save or Close Unless Cells are Filled Sometimes you may want to prevent the workbook from being saved or closed unless data has been entered into certain cells, such as for on-sheet forms. The VBA … 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
