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.

A huge Excel table comes in with lots of columns and rows, but in some cases a column or row is completely empty, and the table needs to be condensed...

For any given Friday – like Black Friday 24th, when can I expect it to happen? For any given year, which date is the Black Friday so one can get specials? And as a bonus question, when will we have another Black Friday sale on the 24th of November?

On this lazy “Friday Afternoon”, can one figure when the next Black Friday is without having to look at full calendars or consulting the internets?

Sometimes, I am happily working away in Power Query when I hit a problem. Features are not there when I need them, something I’m sure should have worked doesn’t...

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

It’s been a big week in Australian politics, as the results of a voluntary postal survey have come back suggesting that Australians overall are in favour of legalising same sex marriage...