View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Scoops Scoops is offline
external usenet poster
 
Posts: 108
Default Move active cell?

On 25 Jul, 13:58, "Kent McPherson" wrote:
How do I move the active cell in a range inside a loop?


Hi Kent

You could use:

Dim cell as Range
Dim myRange as Range

For Each cell in myRange
cell.select
DoMyProcess
Next

Note that you don't actually need to select a cell in order to
interact with it, unless you specifically want to do that, so the
above minus "cell.select" would suffice.

Regards

Steve