Would an array formula be OK (entered with shift ctrl enter) be OK. In this
case simply select the required range, enter the formaula as you gave it and
hit shift+ctrl+enter ????

"firsttimer" wrote:

Is it possible to insert a range of cells depending on cell value,
e.g.
A1 contains "Sheet2!B1:D3"
result should be
A B C
2 B1 C1 D1
3 B2 C2 D2
4 B3 C3 D3