+ Reply to Thread
Results 1 to 2 of 2

fixing cell/ formula ranges

  1. #1
    Registered User
    Join Date
    11-20-2008
    Location
    England
    MS-Off Ver
    2007
    Posts
    65

    fixing cell/ formula ranges

    Hi All,

    I've got the following formula on sheet1,

    Please Login or Register  to view this content.
    the "Active" sheeet is where the data is.

    On the active sheet is a macro that creates a row on row9, thereby pushing the data down the sheet, and hence changes the above formula to start
    calculating form row 10 !!

    can anyone help so the above formula, no matter what, always sums from row 9
    Last edited by luke_p; 03-20-2009 at 06:54 AM.

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: fixing cell/ formula ranges

    Remove "$" from "$9".

+ Reply to Thread

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