Thread: Active Cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Active Cell

Hi
activecell.offset(1,0).select
and
activecell.offset(-1,0).select

--
Regards
Frank Kabel
Frankfurt, Germany

"Bookwizerd2" schrieb im
Newsbeitrag ...
Hi all,

Excel 2000

What is the macro command to move the active cell up and down a row

without
giving specific cell references in the same manner you can move

columns right
and left with "ActiveCell.Next.Select" and

"ActiveCell.Previous.Select"
respectively.