For those new to workbooks with macros

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

If you are new to workbooks with macros here is a short 2 min video on the quick setup needed to work with them on your PC’s Excel and some basic points to be aware of…  

  •  
  •  
  •  
  •  
Tagged with:

Great article on VBA efficiency

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

I don’t often re-post, but hard not to with this really good post on Excel VBA speed and efficiency  Well worth the read. https://www.soa.org/news-and-publications/newsletters/compact/2012/january/com-2012-iss42/excel-vba-speed-and-efficiency/

Tagged with: ,

Stand up comedian Matt Parker on Excel spreadsheeting

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

I hope you enjoy this YouTube from Matt Parket’s stand up routine on Excel spreadsheeting

Tagged with:

Personal Macros – Locked & Unlocked cells

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

This is another handy personal macro I use in my day to day spreadsheeting and application building.  It sits in my Add-In which has it’s own tab on my custom ribbon, but you might just use the ribbon QAT or

Tagged with: ,

Watch great videos on what’s new in the Excel world from Microsoft’s Ignite 2018 Seminar

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Want to sit in on a world class Excel seminar?  Microsoft has a fantastic seminar Microsoft Ignite for tech professionals including Excel Pros, the most recent was held just over a month ago in Orlando U.S. Sept 24-28 2018.  You

Tagged with: ,

Kanban Tool for Excel project management

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

This blog is about a really great tool I discovered to use for client Excel work, called Kanban Tool.  For significant projects like anyone else I need to plan how I should develop a spreadsheet and keep track of all

Tagged with:

Are guys really using Excel for this?

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Was enjoying my coffee this cold winter’s morning, reading my nerdy ipad edition of  The Australian newspaper and there was this article!   Read the first paragraph!  No way!  If there are men out there using my beloved Excel for that

Tagged with:

Macro to fix Duplicate Conditional Formatting rules in Tables

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Following on from my recent post of Fix duplicated Conditional Formatting Rules , I mentioned Debra Dalgaleish’s website page had some great VBA to fix duplicated and messy Conditional Formatting.  I tweeked this code just a bit so that all

Tagged with: , , , , ,

Alternatives to Conditional Formatting

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

In my recent post of Fix duplicated Conditional Formatting Rules , I mentioned you should be careful using Conditional Formatting in situations where you have thousands of rows of data or calculations as this can be a drain on performance. 

Tagged with: , , , , , , ,

Fix duplicated Conditional Formatting Rules

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

If you have ever been confronted by the duplicated, fragmented and almighty mess your conditional formatting (CF) rules can get into, I hope the following post helps you.  Basically this situation arises as you go about day to day coping

Tagged with: , , , ,

Entering a relative formula in VBA using the macro recorder

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

I did this very thing today, so thought I would share this tip with you as it saves me a lot of time.   Say you wanted to have this formula go into column 8 of the range you created in

Tagged with: ,

Using a Table Name prefix for productivity

If you like this post please share it!
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

A few years ago I picked up on this gem of a tip of Dick Kusleika in his blog at his The Daily Dose of Excel site on using the Table Name prefix of “tbl”.  If you are not dropping

Tagged with: , , , ,
Top