Can anyone tell me either by way of a w/s function or VBA how to find a
named range and then paste that named range in to another sheet.......i
have a worksheet that has a list validated cell when i choose a name out
of that list and it appears in B1 i would like the matching named range
to be found and pasted in to B4:C21 on the same sheet, i tried a
combination of HLookup and Vlookup to no avail and i tried a varation
of =INDEX(xx,Match(x,xx)) but that didnt work right either as i was
trying to pick each cells data individually but in reality the named
range as a whole can be copied and pasted in to the range.

Any ideas?

Regards,

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=541264