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