Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    May 2002
    Location
    Loveland, Ohio, USA
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cell Reference (Office 2000)

    I have been having some issues with Absolute versus Relative Cell references, and would like to know if there is a way to:

    1) Change all cells in a sheet to Absolute or Relative Reference
    2) Change a range of cells to Absolute or Relative Reference
    3) Change the default style to Absolute Reference

    Option #2 above would be the best one since going into each formula, selecting the reference and hitting "f4" to toggle the type is a bit of a pain.

    Thanks for any help!

    Andy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cell Reference (Office 2000)

    See the long thread starting at <post#=173133>post 173133</post#>, especially the code samples in the second half of the thread.

Posting Permissions

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