This is really a confluence of annoyances. For a variety of reasons, some of which make no sense, we need to have formatted descriptions for our products in the csv files imported into our new inventory management system. This system will only allow formatted descriptions of up to 35 characters per line. The system wraps unformatted descriptions automatically, but formatted descriptions would get truncated if you give it more than 35 characters.
Manually creating multiple cells of less than 35 characters each would take forever, so my first foray into VBA was automating this process. I'm not that familiar with Excel or VBA, so when I encountered my first error cell, I had no idea what it was. I was getting a type-mismatch error, and when I looked at the data in the cell, I saw this "#NAME?". I didn't even know that this indicated an error!
So I Google "#NAME?" and I get 2 billion results. Now, Excel is popular, but that couldn't be right. And I couldn't convince Google to search for the exact string I entered. They insisted on searching for what they, in their infinite genius, decided I wanted to search for.
Google, here's a free hint. If I typed in "#NAME?", I want to find web-pages with the exact term "#NAME?". Sounds kinda obvious, I know, but there it is. Had I wanted to search for "NAME", I would not have typed the "#" and the "?"!
When I finally realize that "#NAME?" indicates an error in the cell, I search for "excel error cell". The first result gives me exactly what I need, a table of error messages and what the error is. Included in this table is my "#NAME?" error, so why can't I find that directly with Google?
Item of the Day: Jacuzzi Morphosis BR70 - Jacuzzi Air Tubs