• ## Syndicated Articles

### Highlight Subtotals for Easy Reading

by Published on 2012-05-17 05:48 AM     Number of Views: 18000

One of the things that always struck me as odd about using subtotals is that only the words in the subtotals turn bold, and not the actual subtotals themselves. With a long list of data this can make it hard to see which numbers are the subtotals amongst the data. Fortunately this is very easy to fix using conditional formatting.
...

### Approximate Matches With VLOOKUP

by Published on 2012-03-22 06:00 AM     Number of Views: 26510

The purpose of the VLOOKUP function is simple: it looks up data in tables and returns results from a different column. So if you have a table of products, for example, you could ask VLOOKUP to return the price for an item given the ID of the product.

But VLOOKUP is more than just that; it is the gateway to real Excel knowledge. The VLOOKUP function contains everything that a function can throw at you: multiple required parameters, optional parameters with defaults, and needs both ranges and numeric data in its input strings. If you can master this function, you can master ANY other function in Excel.
...

### Understanding Dates in Excel

by Published on 2008-03-30 07:44 AM     Number of Views: 15883

What are dates?
This may seem like a strange thing to ask but, as far as Excel is concerned, dates are numbers. By storing them as such, it gives us the ability to add or subtract days to/from a date, as well as get the difference between two dates. If dates were stored as text, this would not be possible. Storing dates as numbers also allows us to construct far more complicated formulas, based on results that we may want to know.
...

### Using a Treeview Control

by Published on 2007-02-02 08:31 AM     Number of Views: 117614

This is a tutorial on the creation of a simple Treeview control on an Excel userform. For the purposes of this example, we'll be populating the Treeview control with worksheet names and the addresses of cells with formulas in them.

The article is intended for intermediate level VBA coders, meaning that you should be comfortable with navigating the Visual Basic Editor (VBE), and preferably have created a least a few userforms in your experience. With the exception of Treeview specific items, I will not be covering terminology or explaining things in great detail, so if you're a beginner, you may need some additional help to follow all the steps.
...

### Using Help in Your Applications

by Published on 2006-10-22 05:28 AM     Number of Views: 30448

Introduction:
One of the biggest parts lacking in user constructed solutions is documentation in the form of help files. As coders, we usually find it easier to build the application than explain to someone how to use it properly. After all, what we write in code is rarely read by others, and most novices think it's gibberish anyway. Actually explaining what you do in plain English (or whatever language you use) can be quite difficult. Ironically, it is this very fact that tells us why help files are important... write it down once, nicely, and you should never have to explain it again.

Office makes use of Compiled HMTL (chm) help files, which can be created by any number of applications. While writing these documents can be a difficult task of explaining yourself to the end user, the final trick is getting the compiled file to work with your application. This article was written to help ease the burden of the coding part, but unfortunately I'm going to leave the actual construction of the files to you, although I will give you some pointers to get started.

Programs to build help files:
First thing is first, you'll need to install a copy of Microsoft's HTML Workshop, if you don't have it installed already. This program is used by all Help authoring software, so it's not really an optional thing.

The next step is to find a suitable HTML Help compiler. Personally, I use West Wind Help Builder. It has an excellent FAQ included on how to start using the program, and allows for creation of some very rich help files. I'm a big fan of being able to easily write my documents including screen shots, hyperlinks, and context IDs, and West Wind Help makes this fairly easy. It even integrates nicely with another fantastic product, Tech Smith's SnagIt, for capturing nice screen shots. There are trial versions of both products available at the links provided.

Other programs do exist, such as "Help n Doc", Shalom Help, HelpScribble, Robohelp and others, but I cannot speak to their usefulness, as I have not worked with any of them extensively.

Built in Help methods:
Microsoft Excel does have some built in help constants and methods that you can use to deliver ...

### Five Very Useful Functions For Working With Text

by Published on 2006-01-10 09:08 AM     Number of Views: 29490

This page is dedicated to explaining how to use what I believe are the five most valuable formulas for working with text in Excel. They are useful on their own many times, but can become immensely powerful when nested (combined) with other formulas later as well. Mastering these five formulas will open up the door to many things that you may have never thought possible. All of these formulas can be used by putting actual text in the "text" area, but their true power is unlocked when using them on cell references as the data can then be dynamic.
...

### Export A Range Of Excel Data To A Database

by Published on 2004-12-21 08:09 AM     Number of Views: 44320

Macro Purpose:
• Exports a table of data from Excel into a database, using an ADO connection to pass SQL strings.

...
• ### Recent Forum Posts

#### Delete Specific Text from Column of Cells

It would appear that your data is uniform in layout, but might you have a line with 2 characters to remove (e.g. RM), and also a ZZ+number to remain?...

Hercules1946 Yesterday, 11:38 PM

#### Rename the pictures using excel

Hi Guys,

I need your help. I'm using mac. I try to figured out for this code for change the old names of picture to new name.

...

jcsc83ph Yesterday, 09:53 PM

#### Setting Up Names in a Table as Row Label

Excel Version: Microsoft Office Professional Plus 2013

I'm trying to count the number of times a name is assigned to a group/role from a...

thk12205 Yesterday, 09:46 PM

#### data anlysis

In row 2, say column W, this formula array-entered (that's Shift+Ctrl+Enter, not just Enter):
=DATEDIF(INDEX(\$A2:\$K2,MAX((\$L2:\$U2="LARC")*(COLUMN(L2:U2)))-10),V2,"M")...

p45cal Yesterday, 08:34 PM

#### Help with Sorting Data Please

Code:
```Sub FishCount()
With Sheets("catch-return")
For r = 2 To .Range("A1").End(xlDown).Row```
...

NoS Yesterday, 07:51 PM