Daily Dose of Excel
I have these four favorites defined in Outlook: From the inbox, I could hit Shift+F6 to get into the Favorites area but sometimes I would end up in no man’s land and couldn’t figure out how to get back into the inbox. So, god forbid, I had to use my mouse. I wrote this macro: Sub NavigateFavorites() Dim ae As Explorer Dim oMod...
In response to https://nolongerset.com/all-about-indenting/ ::ThisPath::ThisWorkbook.Path & Application.PathSeparator ::ppg::Public Property Get ::with::With {End}{Enter}End With{up}{end} :*:then`n::Then{Enter}{Enter}End If{up 1}`t ::forarray::For i = LBound(arr) to UBound(arr){Enter}{Enter}Next i{up}`t :*:for :: ;when...
I have a fairly slow running macro (~20 seconds) that works fine on one computer, but never finishes on another. If finally decided to figure out why. (Big Daddy is the nickname of the guy who started this golf league way before my time. I am not Big Daddy, although maybe I should be.) First I noted that Windows Defender was using a lot of CPU and...
Do you use Range names in Excel? Today I have updated my 100% free Excel Name Manager add-in with two new features: – Edit the name’s comment – Filter Lambda names https://jkp-ads.com/officemarketplacenm-en.asp Here’s a screen-shot: Regards, Jan Karel Pieterse jkp-ads.com
Hi There, It’s been a while since I last posted here. Today I have released an update of my RefTreeAnalyser utility. The tool now allows you to add a Table Of Contents to your workbook which contains lists of all sheets, all charts and all Pivottables: In addition I have added a Feedback button to enable my users to send their complaints -I mean...
In Excel 2019 16.0.10361.20002 32-bit, when I open a file from a userform (which for me is always), the hotkeys on the Ribbon don’t work. Here’s how I reproduce: In a new workbook, add a userform named UserForm1. Add a commandbutton to the userform. Paste this code in the userform’s code module. Private Sub CommandButton1_Click() Application.RecentFiles(1).Open ...
Build your own newsfeed
Ready to give it a go?
Start a 14-day trial, no credit card required.