Microsoft Releases Office 2010 Details
Microsoft has begun releasing details of its new release of Microsoft Office, called Office 2010. I’ve already signed up for the Technical Preview of the software, but unfortunately I’m still on the waitlist.
Read More
Excel Hints Is Back Up and Running
I’d like to apologize to anyone that has attempted to visit Excel Hints in the 7 hours or so. All the links that were broken appear to be fixed now.
If you were interested in the post from earlier today, click on the following link: Check if a Cell Contains Text.
Again, Thank you for you patience and for visiting Excel Hints.
John
Check if a Cell Contains Text
Excel provides an easy method to determine if a particular cell contains text. Using the IsText function will return True or False after checking the given cell. Let’s take a look at at how to use this function.
IsText Example
For this example, let’s imagine Cell A1 has the text “Red”, and Cell B1 contains the number 5. Using the IsText function would look like this:
Read More
Count the Number of Open Excel Workbooks
This may be the shortest post on Excel Hints to date. There are many times when you are working on your project that you may need to know the number of open workbooks open on your desktop. There is a simple way you can use a built-in Excel feature to have it do the counting for you. Take a look at the example below:
Run a Macro When Opening a Workbook
There may be a time when you want a macro to run automatically every time you open a workbook. Excel has a built in way to help with this – the Auto_Open subroutine (Workbook_Open achieves a similar result). Each time Excel opens, Auto_Open() will run only once when the workbook is open. Let’s go ahead and take a look at an example.
Read More
