Results 1 to 2 of 2

Relative References Not Updating Properly

Threaded View

  1. #1
    Registered User
    Join Date
    11-21-2008
    Location
    Texas
    Posts
    1

    Relative References Not Updating Properly

    I have a worksheet with cells containing a simple formula like =b1/a2. If I copy that formula to a new column wanting the formula to become =c1/b2, what I end up with is =c1/a2. I can't figure out why the denominator won't change along with the numerator. If anyone can explain what's going on and if there is a way to make it work the way I think it ought to, I would be most thankful.

    TIA for any suggestions.
    pb
    Last edited by VBA Noob; 11-21-2008 at 03:28 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1