Skip to content

EXCEL TABLES

All tables. All the time.

  • Book
  • Table Tools
    • Table Tools Excel Add-In
    • Download
  • About Us
  • Contact Us
  • Newsletter

Rock 2017

Be you

EXCEL TABLES EXCEL TABLES

Data Validation Under Table

December 6, 2016 ZackGeneral, VBA

Tables are great, we love them. But we don’t always love them. If using data validation in a column, it works great inside of a Table. But what about in the cells underneath the Table? Not so much. In this blog […]

Read more

Add rows to all Tables in a worksheet

November 24, 2016November 24, 2016 ZackGeneral, VBA

Adam asked a question in the how to find the last row on a sheet with tables post. He wanted to know how to insert a row into every Table in the worksheet. Well, it’s a slightly different problem than […]

Read more

Append data to a Table with the Total Row showing

October 17, 2016 ZackData, General, VBA

Working with Tables is great. I mean, did you even see where you’re at? Our name says it all. But sometimes they just don’t work quite like you would think. As in life, we work with what we have. A […]

Read more

Excel Summit South in Review

March 30, 2016 ZackGeneral, Misc

A few short weeks ago, several experts from around the world began a whirlwind-tour across New Zealand and Australia, to share their Excel and modeling knowledge. I must say, it was one helluva’n experience which I was blessed to be […]

Read more

Office 2016 Breakdown

November 17, 2015November 17, 2015 ZackGeneral

Hello! It’s been a while since I’ve posted. Apologies for the delay, but life has been good. So much has happened the last few months, with so many shiny, new things to talk about! And I love shiny, new things. […]

Read more

Office 2016 for Mac is here!

July 9, 2015 ZackGeneral

While I don’t use a Mac, I can appreciate cross-platform capabilities. That and my wife uses a Mac. So I’m excited to let you know that Office 2016 for Mac is finally here! Here’s what you need to know: Get […]

Read more

The Einstein Riddle: A logic puzzle

July 4, 2015 ZackGeneral

A friend of mine posted this on their Facebook. I’d heard of it but never tried it out myself. FSo I figured, why not, and gave it a go. If you like logic puzzles, this is for you! This doesn’t […]

Read more

How to find the last Table row on a sheet

June 4, 2015November 24, 2016 ZackGeneral

There was a really good blog post by Jon Acampora over at ExcelCampus with a VBA tutorial on finding the last row, column, or cell on a sheet, and three different methods to do that with (End, Find, and SpecialCells). […]

Read more

Choosing a File Format

May 5, 2015 ZackGeneral, Misc, VBA

A good question which keeps popping up is what file format should you choose for an Excel file. Excel can save in a variety of formats. I’m assuming we’re only dealing with Excel 2007 or later and will not be […]

Read more

Run Scheduled Macro

April 23, 2015May 7, 2015 ZackMisc, VBA

By Zack Barresse Synopsis Today at PASS BA 2015 I spoke in a session about the topic of Excel Add-Ins. Nearing the end of the session an attendee asked an interesting question which I thought worthy of a blog post. What […]

Read more

Posts navigation

Older posts

Copyright © 2015-2016 Data Automation Professionals, LLC

All rights reserved. Any information on this website is given as-is without any given, expressed or implied warranty.

Cool Tools

Peltier Technical Services

Contextures Inc.

Holy Macro Books
  • Book
  • Table Tools
  • About Us
  • Contact Us
Powered by WordPress | Theme: Astrid by aThemes.