LePig
09-22-2016, 09:26 AM
Hi,
I need to copy a table from one worksheet to another when something is added. It is within the worksheet_change event.
However i keep getting 424 error code
Dim KeyCells_2 As Range
Set KeyCells_2 = Sheets("Sheet1").Range("Table3[[All],[Languages]]").Value
' Me.Range ("C152:C169")
If Not Application.Intersect(KeyCells_2, Target) Is Nothing Then
Application.EnableEvents = False
Sheets("Sheet1").Select
Sheets("Sheet1").Range("Table3[[#All],[Languages]]").Select
Selection.Copy
Sheets("Sheet2").Select
Range("C6").Select
ActiveSheet.Paste
End If
Any help would be greatly appreciated.
Kind Regards
I need to copy a table from one worksheet to another when something is added. It is within the worksheet_change event.
However i keep getting 424 error code
Dim KeyCells_2 As Range
Set KeyCells_2 = Sheets("Sheet1").Range("Table3[[All],[Languages]]").Value
' Me.Range ("C152:C169")
If Not Application.Intersect(KeyCells_2, Target) Is Nothing Then
Application.EnableEvents = False
Sheets("Sheet1").Select
Sheets("Sheet1").Range("Table3[[#All],[Languages]]").Select
Selection.Copy
Sheets("Sheet2").Select
Range("C6").Select
ActiveSheet.Paste
End If
Any help would be greatly appreciated.
Kind Regards