How do I move the active cell in a range inside a loop?

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