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
|