Little Looping

**Stuie** · 10-17-2006, 09:36 AM

im running a loop between cells H23 and H30. when it gets to H30 i want it to continue from J23, which i can do but i dunno what to write on the until line coz i tried

do until activecell = range("H30")

or

do until activecell Is range("H30")

or

do until range("H30") Is activecell
etc...

any ideas any1

**Bryan Hessey** · 10-17-2006, 10:31 AM

Originally Posted by Stuie

im running a loop between cells H23 and H30. when it gets to H30 i want it to continue from J23, which i can do but i dunno what to write on the until line coz i tried

do until activecell = range("H30")

or

do until activecell Is range("H30")

or

do until range("H30") Is activecell
etc...

any ideas any1

maybe try ActiveCell.Address = "$H$30"

hth
---