You ever need to go through a workbook you’re working on and delete a bunch of sheets that have nothing in them? Maybe you’re creating a new automated report that requires you to plunk down a large chunk of data in a new workbook, but when you create that new workbook, it creates it with “Sheet1”Continue reading “Excel Geeking: Removing All Empty Sheets using VBA”
Tag Archives: programming
Excel Geeking: Using Special Characters in ListObject Column Names in VBA
This is a short one, but a REALLY specific one. Recently (i.e., today) I was tinkering with some List Objects, a.k.a. “tables” in VBA. All I was trying to do was to clear the contents of a column. Easy enough. It looked something like this: No Excel love. It kept throwing me an error. Specifically, errorContinue reading “Excel Geeking: Using Special Characters in ListObject Column Names in VBA”
Excel Geeking: Extracting Outlook Address Book Information To Excel Using VBA
Yeah, I know there are a lot of posts out there about this already. So here’s another. Truth be told, when I first went searching for items on this topic, I couldn’t find what I was looking for. Granted, it’s not outside the realm of possibility that I simply suck when it comes to a decent GoogleContinue reading “Excel Geeking: Extracting Outlook Address Book Information To Excel Using VBA”
Excel Geeking: Counting Recurring Instances of the Same Value Using a Formula
A coworker of mine, who works in another department, had a spreadsheet her group uses to manage what gets pushed out to the stores and when. If you’re in retail, and retail IT especially, you know you don’t mess with the stores anymore than necessary. They are the moneymakers, and you don’t want to beContinue reading “Excel Geeking: Counting Recurring Instances of the Same Value Using a Formula”
Excel Geeking: “That Command Cannot Be Used On Multiple Selections” Error On A Single Cell
UPDATE (18-FEB-2015): Remember this? Yeah, unfortunately I do too. I wish I could say that my update from September was the end of the conversation. Sadly, it wasn’t. I started getting this error again and there was no random PowerPivot data connection in my workbook. When I saw it pop up again, I was absolutelyContinue reading “Excel Geeking: “That Command Cannot Be Used On Multiple Selections” Error On A Single Cell”
Excel Geeking: Unwinding a Crosstabbed Dataset
Sometimes you have to work with a data set that is not in a state conducive to, well, anything. I’m thinking specifically about crosstabbed data sets. More than once I’ve had to deal with a data set that looks like this: Oh, if only there were a way to unwind this file so that it wasContinue reading “Excel Geeking: Unwinding a Crosstabbed Dataset”
Excel Geeking – How I Control Releases of Excel Templates
In my current position, I manage the care and feeding of a type of planning system. The whole thing has been built in Excel, and presents more than a few challenges. Since I didn’t do the original construction, I inherited the application, and without being able to make major back-end changes, I’ve only been ableContinue reading “Excel Geeking – How I Control Releases of Excel Templates”
Excel Geeking: Using VBA And ADO To Change Data to SharePoint Lists
I don’t get a ton of hits on this blog. But for the hits I do get, most them are focused on the Excel stuff. And of the Excel stuff, one of the most popular is Using VBA and ADO To Pull Data From SharePoint Lists. Because of this, I felt the need for aContinue reading “Excel Geeking: Using VBA And ADO To Change Data to SharePoint Lists”
Excel Geeking: Using VBA And ADO To Pull Data From SharePoint Lists
I’ve been developing a SharePoint team site for my area which will house all kinds of information about the process and tools that I and my team support. I’ve been tinkering with the team site now for about two weeks. I’ll say this about SharePoint: moving around it is definitely not intuitive, and you canContinue reading “Excel Geeking: Using VBA And ADO To Pull Data From SharePoint Lists”
Excel Geeking: RowSource For A Control In A Modeless Userform
I know that the title of this post is going to sound like a Charlie Brown adult talking to most casual readers. But what I really want in a blog post title is something that is going to really tell me what is inside so that I don’t waste my time. Which is what IContinue reading “Excel Geeking: RowSource For A Control In A Modeless Userform”
Scott C Lyerly 