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
What Are You Looking for Help With?
As a follow up to the poll How Often Do You Use Excel Macros, to further lead the direction of Excel Hints, we asked you the question:
Are you looking for more help with Macros or Formulas?
Loading ...