Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Glasgow, Lanarkshire, Scotland
    Posts
    82
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macros and relative Cell references (Excel 2000 SR-1)

    Help advises that to use relative cell references, user should use Tools|Macros|run new macro and opt to use relative cell references. This option is not avialabe at this location. Can anyone advise?

  2. #2
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macros and relative Cell references (Excel 2000 SR-1)

    Have you actually started recording a new macro?

    If not, do so and the 'STOP RECORDING' toolbar should appear somewhere on your screen. The button on the right toggles between absolute & relative references.

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    Glasgow, Lanarkshire, Scotland
    Posts
    82
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macros and relative Cell references (Excel 2000 SR-1)

    Thanks, that appears to do the trick.

    Pity MS Help misses out this vital step - it isn't logical to start recording the macro and then changing to relative - or is it?

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Flims, Switzerland
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macros and relative Cell references (Excel 2000 SR-1)

    it is logical, because you might want to change from relative to absolute half way thru recording a macro and vice versa

  5. #5
    Star Lounger
    Join Date
    Feb 2001
    Location
    Glasgow, Lanarkshire, Scotland
    Posts
    82
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macros and relative Cell references (Excel 2000 SR-1)

    My mistake, of course it is.

    Still annoyed at Help though.

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Flims, Switzerland
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macros and relative Cell references (Excel 2000 SR-1)

    agreed. the help is a bit misleading...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •