Thread
:
VBA: move to the next cell down from anywhere in the sheet
View Single Post
#
2
Posted to microsoft.public.excel.programming
Nick Hodge
external usenet poster
Posts: 1,173
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
Reply With Quote
Nick Hodge
View Public Profile
Find all posts by Nick Hodge