|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Defining a range using a cell reference
B2:INDEX(B2:IV2,A20)
jagbabbra wrote:
thank you for the suggestion but this seems to only work if you refer to
a cell that has an address in ... eg if you use indirect the cell you
refer to must contain (A11) or something to that effect.
I have a cell that contains a number and would like to use that to
define how many columns the range must cover.Eg If i start my range at
B2 and my reference cell (lets call that A20) has the number 3 in then
my range should be B2 : D2
Please can you shed some light on this, cheers
--
jagbabbra
------------------------------------------------------------------------
jagbabbra's Profile: http://www.excelforum.com/member.php...o&userid=32525
View this thread: http://www.excelforum.com/showthread...hreadid=548517
|