Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
GK GK is offline
external usenet poster
 
Posts: 17
Default how do I set up a macro that will move the cursor down one cell?


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default how do I set up a macro that will move the cursor down one cell?

Sub downer()
ActiveCell.Offset(1, 0).Select
End Sub

Sub downer2()
ActiveCell.Offset(1, 0).Interior.ColorIndex = 3
End Sub


Gord Dibben MS Excel MVP


On Thu, 16 Nov 2006 15:52:01 -0800, gk wrote:


  #3   Report Post  
Posted to microsoft.public.excel.programming
GK GK is offline
external usenet poster
 
Posts: 17
Default how do I set up a macro that will move the cursor down one cel

thank you.

"Gord Dibben" wrote:

Sub downer()
ActiveCell.Offset(1, 0).Select
End Sub

Sub downer2()
ActiveCell.Offset(1, 0).Interior.ColorIndex = 3
End Sub


Gord Dibben MS Excel MVP


On Thu, 16 Nov 2006 15:52:01 -0800, gk wrote:



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to move cursor one cell right Kodak1993 New Users to Excel 3 September 23rd 08 02:00 AM
Visual basic macro move cursor down 1 cell Roger Excel Worksheet Functions 1 September 12th 06 08:09 PM
Macro to move the cursor to a different cell on the same row Ann Wong Excel Programming 4 August 31st 04 01:59 AM
macro to move cursor Bob S[_2_] Excel Programming 4 January 15th 04 03:36 PM
need help with macro -move cursor down then home Ftca Excel Programming 5 October 16th 03 01:24 PM


All times are GMT +1. The time now is 03:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"