Many thanks to all who posted suggestions. The three lines of code
below are exactly what I needed.

Fred Holmes

On Mon, 1 Jun 2009 18:38:56 +0100, "Patrick Molloy"
wrote:

dim cell as range
for each cell in selection.cells
. . .
next