The sixth in a series about using ListObjects to manipulate Tables within an Excel workbook in VBA featuring the Headers Range.

Power Query and Power Pivot work well together, however Power Query is not exclusive to Power Pivot though, as it may be used with ordinary PivotTables. There is a good reason for doing this too...

This is neither the Italian COUNT function nor an Excel calculator dedicated to tallying the number of times the letter “a” occurs in a spreadsheet...

The fifth in a series about using ListObjects to manipulate Tables within an Excel workbook in VBA featuring DataBodyRange.

This week I look at combining several Power Query functions in order to standardise some incoming data...

Need a function you can COUNT on?

How use DataBodyRange property to manipulate table ranges.

The scenario is familiar, a huge Excel table comes in with lots of columns and rows, but in some cases a column or row is empty and it needs to be condensed...

This function returns the hyperbolic cotangent of a hyperbolic angle. Clear as mud?..

This is the third in a series about using ListObjects to manipulate Tables within an Excel workbook in VBA.