Sub range from a range
 

Hi all

I have a dynamic named range that is based on an offset formula. Say
that it currently references to A11:C50. How would a formula that
selects everything except the first column from that range (B11:C50)
look?

Thanks


--
deepthink
------------------------------------------------------------------------
deepthink's Profile: http://www.excelforum.com/member.php...o&userid=32467
View this thread: http://www.excelforum.com/showthread...hreadid=522549

Sub range from a range
 

deepthink

this expression will return a reference to a subrange of _range_
according to your specifications:

OFFSET(_range_,0,1,,COLUMNS(_range_)-1)

HTH
Kostis Vezerides

Sub range from a range
 

Thanks Kostis Vezerides


--
deepthink
------------------------------------------------------------------------
deepthink's Profile: http://www.excelforum.com/member.php...o&userid=32467
View this thread: http://www.excelforum.com/showthread...hreadid=522549