Excel – How to Remove Duplicate Rows in Excel 2013

Excel – How to Remove Duplicate Rows in Excel 2013

Need to know how to delete duplicates in Excel 2013?  Well, thank you Microsoft!  I bet a million hours have been spent over the past 10 years where people did nothing but remove duplicate rows from a Spreadsheet.  Microsoft has just improved the GDP of the US by .0001% with a single Feature. The Remove [...]

Read full story Comments { 1 }
How to Make an iOS Demo Screencast Video for Your App

How to Make an iOS Demo Screencast Video for Your App

Just so you know, this is AWESOME!!  You’ve worked hard to make your App great.  It’s on the App Store, and now you’re ready to showcase it with a demo video.  You start out with the iPhone or iPad Simulator, but that’s really limiting.  You’ve got photos and maps and other stuff that just aren’t [...]

Read full story Comments { 0 }
Coinshooter – iPhone App for Metal Detecting

Coinshooter – iPhone App for Metal Detecting

While this is not a Metal Detecting blog, I do capture my iPhone exploits here, so this is mostly relevant I’ve just released my 5th iPhone app, and the one that I am most excited about.  I’m probably always excited about the newest one, but this one really solves a specific set of needs for [...]

Read full story Comments { 0 }

So long, and thanks for all the Search!

Google has announced iGoogle’s demise.  iGoogle and the excellent, unified search/address bar in Chrome were the two primary ways I interacted with Google.  Google even gave me a friendly note on my iGoogle page about the November 1, 2013 doomsday, advising me to pack my bags early and be on my way to greener pastures. Why, [...]

Read full story Comments { 1 }

Mac OS X – Working with NSImage, Core Data, and Address Book

Sorry this isn’t in tutorial format, but I want to capture this so I don’t have to search quite so long next time ! While I’ve done several iOS apps, I’m getting started on my first Mac app.  If you’ve spent a year or so with iOS and you think that jumping to the Mac’s [...]

Read full story Comments { 2 }
c-sharp-nullreferenceerror

C# – NullReferenceException with TableAdapter and Scalar Values

Ok, I’ve been hacking around this particular problem for a month now, but think I’ve got a bead on how to stop it. So, I hope this helps someone! The Situation I’ve got a TableAdapter in C# and I’m using a Query to return a scalar value that ultimately becomes a double data type. The [...]

Read full story Comments { 4 }
iOS 5 – Problem Setting an Image for UINavigationBar Background

iOS 5 – Problem Setting an Image for UINavigationBar Background

iOS 5 has made it much, MUCH easier to set an image as the background of your UINavigationBar. There are dozens of tutorials out there that will get you there, and I tried a half dozen of them, but still couldn’t get it to work. The code itself is very simple, and here it is: [...]

Read full story Comments { 1 }

C# / VSTO – Using Excel Ranges

Using Visual Studio Tools for Office (VSTO) with Excel lets you use C# (or your other favorite .NET language to leverage the power of Excel. But you will have to learn how the syntax for the Excel object model as opposed to just using VBA syntax. This post shows you how to use Excel ranges [...]

Read full story Comments { 0 }

C# – VSTO – Get Last Used Row or Cell in Excel Spreadsheet

I have had the opportunity to get my fingers dirty with Visual Studio Tools for Office, at long last.  My project brought me back to an old familiar problem in Excel, finding the last used row in a spreadsheet. This applies equally to C#, VB, and VBA.  You just have to get access to the [...]

Read full story Comments { 2 }
useful-auth-t-codes

SAP – AUTH – How to Find Users who have Access to a T-code

In the Business Analyst role in an SAP shop, it may be helpful to know what Roles or Users have access to a particular transaction code.  Here’s a little tip that lets you do all sorts of queries about the authorizations in your SAP system. Use T-code:  AUTH to Access “Infosystem Authorizations” Menu To get [...]

Read full story Comments { 5 }