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: , , , ,

My First PowerApp

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

I talk a lot about Excel automation.  Automating with Excel helps us be more productive and efficient in our jobs.  Automating tedious tasks using advanced Excel features like Tables, Pivot Tables, Power Query, VBA or macros. The benefits are many

Tagged with: , ,

Google Sheets and Google Forms

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

It’s good to check out how Google Sheets are doing every now and then.  In my view, it just isn’t as powerful a tool as Excel.  Not sure how to say this better because I am not writing it off

Tagged with: , , ,

Autocomplete Workaround for Validation Dropdowns

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

As might know there is no autocomplete functionality with Data Validation dropdowns.  I wonder if the Microsoft development teams are considering this as it would be a wonderful feature.  I sometimes wonder if the validation dropdown was an accidental dropdown

Tagged with: , , , , ,

Rediscovering templates for new workbooks and worksheets

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

I have been having a 1st World problem.  For as long as I can remember, I create a new worksheet and the default cell vertical alignment is set to bottom which I hate.  There it is.  It’s no more than

Tagged with: , ,

Personal Macros – Personal.xlsb or Add-In.xlam?

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

My last blog was on accessing personal macros from my custom ribbon. This blog is about where to store these personal macros.  These personal macros are the ones that save you time and tedious work.  There are basically two ways

Tagged with: ,

My Custom Ribbon using Formulas to Create XML code

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

I recently finished a pet project of creating a custom ribbon in XML driven by an Add-In to access my personal macros.   These are the ones you collect over the years and use in your day to day work  to

Tagged with: , , , , , , , , ,

VBA to Change Pivot Table Source

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

I recently worked on a project that had three distinct and large datasets for different geographical areas in three workbooks.  Starting with the first workbook and dataset in a Table in its own worksheet, I created a worksheet of seven

Tagged with: , , ,

Tip for excluding Outlier data in Pivot Charts

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

Last week I implemented Pivot Charts for a client with three very large data sets, one of which was 30K rows and the other two being > 10K rows.  There was one obvious outlier skewing one of the charts but

Tagged with: , , ,

Tip for creating syntax in VBA for Worksheet formulas

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

I monitor many Excel and VBA blogs using Feedly and see all sorts of tips, code and great solutions to collect and learn from along the way.  There is no better site for VBA than Stackoverflow.com Anyone who has used

Tagged with: , , , ,

Check range for specific characters

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

If you are working with output from other systems (or preparing input for other systems) you might need to find certain characters that cause problems.  In my case I was creating XML code for a custom ribbon from Excel formulas

Tagged with: , , , , ,
Top