Thanks guys I am up and running again straight into another problem I expect

"David" wrote:

for each cl in selection.cells
cl.activate
next cl
--
David


"PraxisPete" wrote:

Hi Everybody
I have code that references to the ActiveCell and I would like to use this
code looping through a range selection. If I code as follows

For Each cell in Selection
€˜MyCode in here
Next cell
This does not change the ActiveCell

How can I loop through a range selection making each cell become the
Activecell

Example
Range("A3,A6,A9").Select
For Each cell In Selection

' Make cell ActiveCell
' Code that references to the Activecell

Next cell

Many Thanks in advance.