"Dave O" wrote in message
ps.com...


Macros can be tricky because they will do EXACTLY what you tell them to
do...

.....and it also does "it" WHEREVER you told it to when you record the macro.
So, if you select a group of cells, but later, the range you want to work on
gets larger or smaller, you'll need a way for the macro to know that. One
method is to name the range of cells, and then edit the macro so instead of
looking for A1 through B12, it looks for a named range called "SortArea", or
some such thing. Named ranges are immensely valuable. Select a group of
cells, then click Insert, Name, Define. Your imagination may tell you some
ways for using this. It's especially handy for making formulas easier to
read.