Excel – Unable to Open https… Cannot Download the Information you Requested
Fix the Excel error "Unable to Open https... Cannot Download the Information you Requested" that occurs when trying to open a hyperlink
Browsing Tag
Excel
Windows – Extract Log On / Log Off Times in Excel
Start monitoring the time your PC is on every day with a simple powershell script and Excel. Track your time spent and expenses.
EXCEL – Highlight Active Row/Column when Cell is Selected (VBA)
Think that you have loads of data with many rows and you need to check them daily for details, or add new data. You might miss things after concentrating on many rows too much time, clicking on a row and reading data from the row above or below. Try row highlighting!
EXCEL – Highlight Active Row/Column with an Underlining Shape (VBA)
Highlight the selected row/rows and column/columns with an underlining shape (line, rectangle etc.).
Excel – Extract Weather Information to Excel Ranges using VBA
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
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
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 when you want to personalize existing Ribbons or create a special Ribbon for yourself.
In this tutorial we are going to cover the first way since it's the easiest. I might cover the 2nd in…
Excel – Formula to Display the Current Worksheet’s Name
Display the current worksheet's name in a formula and its result changes if the name of the worksheet changes.
Excel – Automatic Update of Sequence Number / Current Number in a Table
Do automatic numbering of rows in a Table (SQN, Cur. No) with a formula that reacts with Excel rows instead of cell ranges or values. This automatic numbering updates itself never showing an error and regardless of Table sorting.
