Finding a named range based on cell value and copy/paste to same sheet?
 

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

Finding a named range based on cell value and copy/paste to same sheet?
 

Hi all, i have managed the copying and pasting of the reference
range....i ws trying to be to clever for my own good!, but i have a new
problem, when i run the code below Excel goes through hundreds of
iterations for the one paste is there any way of only getting it to
copy paste once per change in B3?

Regards,
Simon

THE CODE BELOW IS ON THE SCORE CARD SHEET
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.Goto Reference:=Range("B3").Value
Selection.Copy
Sheets("score card").Select
Range("A27").Select
ActiveSheet.Paste
End Sub


--
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