View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default move to the next cell down from anywhere in the sheet

If deleting rows you should be going up, but if you are set doing it the way
you are

Activecell.Offset(1,0).Select

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"jmp" wrote in message
...

I am deleting rows based on a value in a column (< 16) and if the value
is 16 or greater I want to move down to the next row and check that
value and so on. i am using a Do Until value = "".

What is the code for moving down to the next cell below ActiveCell?


--
jmp
------------------------------------------------------------------------
jmp's Profile:
http://www.excelforum.com/member.php...o&userid=29038
View this thread: http://www.excelforum.com/showthread...hreadid=487763