Search code examples
excelrangecell

Excel Define a range based on a cell value (column wise - A to E )

So, for example: My selection is A1:E1 That are five cells. is it possible to let excel determine this by setting a cell value (like A2) to 5.

It for the purpose of easily changes a lot of ranges with one change in a cell value. So if I would change the cell value (A2) to 6. The range would automatically change to A1:F6

Could somebody help me???

Solution

  • Try this formula

    ="=A1:"&ADDRESS(A2,A2,4)