I have code which triggers off a Change Event in a Sheet. When I chang
a cell in the spreadsheet, the code copies and pastes a range withi
this sheet to another range. The problem is that once the copy/past
engages, the code continues be called and loops on continuously. Ho
do I trigger a copy/paste using the Change Event without looping? I
my only option to copy/paste to a new sheet?


Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim Export As Integer


Export = Range("DropDownExport")

Select Case Export

Case Is = 1
Range("FuelTypeName").Copy Destination:=Range("NamePaste")


End Select


End Su

--
Message posted from http://www.ExcelForum.com