I've got a lengthy macro that does lots of formatting depending on the scenario. The only requirement is that the selection is within a table.

One of the tests I need to do (to decide how to do the formatting) is "does this column contain any text". It turns out this isn't as simple as you'd think. For a start, Column doesn't have a Range property (and therefore no Text property). It also turns out that, if you select a column and try and convert that to a range, you get the whole table, not just the column.

The reason for my post is that I'm hoping someone has struck similar problems and has found a workaround. I've searched online, and there are many "solutions", but so far they all fail. And all my attempts to "work around" have failed.