Browsing Category
Guides
Do things you didn’t know were possible. Do regular things better, quicker.
EXCEL – Highlight Active Row/Column with an Underlining Shape (VBA)
649
Highlight the selected row/rows and column/columns with an underlining shape (line, rectangle etc.).
Excel – Extract Weather Information to Excel Ranges using VBA
706
Extract weather information for your hometown for today and the next 8 days directly to Excel cells, by clicking 1 button. This works for over 22.000 cities all over the world by using a free weather API.
Excel – Force Uppercase Text in a Column
403
Forcing uppercase text in a column is sometimes useful if multiple users work on the same file and you want to make this condition by default. Either show an error when they don't insert UPPERCASE text, either make the text UPPERCASE regardless of how they enter it.
Excel – Create a PERSONAL.XLSB File to Store Macros
512
If you are using Excel VBA you might know this already. Storing macros that work in any Excel file can be done in 2 ways:Creating a macro enabled binary file (PERSONAL.XLSB) that loads when you open any Excel file. Normally Excel doesn't create that file.
Creating an Excel add-in (.XLAM, .XLA for older Excel). This is good…
Excel – Formula to Display the Current Worksheet’s Name
325
Display the current worksheet's name in a formula and its result changes if the name of the worksheet changes.
Word – Count Table Cells in Selection
305
Count cells in Word table selection with the press of a button.It comes handy when pasting a range of cells from Excel.