"Chip Pearson" wrote in message
...
You can use something like

ActiveCell.CurrentRegion.Select

Doesn't seem to be working. I'm executing the procedure via a command
button on the worksheet itself - is this a problem? It looks like this:

Private Sub CommandButton2_Click()
ActiveCell.CurrentRegion.Select
End Sub

-gk-