LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
DRH DRH is offline
external usenet poster
 
Posts: 2
Default Relative Reference in a Macro

The Help on Macro says: "8. If you want the macro to run
relative to the position of the active cell, record it
using relative cell references. On the Stop Recording
toolbar, click Relative Reference so that it is selected.
Excel will continue to record macros with relative
references until you quit Excel or until you click Relative
Reference again, so that it is not selected."

However, when I click Stop Recording, the action is
immediate (i.e.: no tool bar appears.) I can't determine
how to invoke the Relative Reference feature.

I must be missing something "obvious."
Help?


 
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 relative cell reference decimal Excel Worksheet Functions 3 May 21st 09 11:36 PM
Relative reference? in macro TRYING Excel Worksheet Functions 3 November 20th 07 12:00 AM
Using relative reference in macro Bas Excel Discussion (Misc queries) 0 March 23rd 06 12:11 PM
Recording a macro with relative reference Shilps Excel Programming 1 April 5th 04 09:16 AM
MACRO Relative Reference Ibrahim Awwad Excel Programming 3 September 9th 03 02:11 PM


All times are GMT +1. The time now is 06:42 AM.

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"