LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default SIMPLE MACRO!!!

I would like to write a macro that moves the cursor down
one row, and then over to column J. I assume I am mixing a
relative reference with an absolute referance so that
moving one row down is relative, and moving over to column
J is absolute.

I tried writing a macro where I entered the "home" key
(which took me to the beginning of the row), then one
arrow key down (which obviously took me one row down), and
then the right arrow key nine times (which landed me in
column J where I wanted to be). I tried the macro in
relative and absolute mode, but the mixing of the elements
didn't work. Does anyone know how to edit the macro to do
what I want? For my use, I need to get to the cell as
quickly as possible, that's why I'm writing this macro.
Thank you very much,
Hugh Millen
 
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
maybe it's simple with macro for this one? driller Excel Worksheet Functions 6 July 16th 07 05:12 PM
Simple macro MikeD1224 Excel Discussion (Misc queries) 1 June 9th 07 12:06 AM
Need Simple Macro jreinert New Users to Excel 2 June 15th 06 03:58 PM
Simple macro help chip_pyp Excel Discussion (Misc queries) 3 January 10th 06 07:57 PM
Need Help With A Very Simple Macro Amca Excel Discussion (Misc queries) 3 May 7th 05 12:10 AM


All times are GMT +1. The time now is 10:22 PM.

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

About Us

"It's about Microsoft Excel"