Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel 2007- Cell ranges

  • 29-11-2009 3:37pm
    #1
    Melinge
    Closed Accounts Posts: 57 ✭✭


    Hi,
    I would like to use a cell range in a number of formulas throughout my spreadsheet, the length of which is user defined.

    I.e. let cell A2= length of the cell range entered by the user
    ,let cell E9= beginning of the range
    I want to use the range E9:E(9+A2), however brackets are the wrong syntax and it does not recognize E(9+A2) as a cell.
    Does anyone know the right syntax for this or is it possible?
    Thanks


Comments

  • #2
    wolfric
    Registered Users, Registered Users 2 Posts: 1,190 ✭✭✭wolfric


    you might need to use a second variable. look up excel maths (that's what i assume you're using)

    http://spreadsheets.about.com/od/excel101/a/Excel_beg_guide.htm


  • #3
    Thoie
    Registered Users, Registered Users 2 Posts: 6,344 ✭✭✭Thoie


    Macros are the only way I can think of to do this, but it would be helpful to know why you want to let the user decide the range. For example if the user is going to fill in the E column, then maybe it might be more useful to let the macro determine the last row in E and just have a "Set Range" button in/around E8.

    Alternatively, if there won't be anything else in the E column, could you just set the range ahead of time to E9:E60000 (or ideally E:E) - most formulas will ignore blank cells.


Advertisement