Hi,

I've designed a spreadsheet that has 2 tabs - Arrivals and Departures.
Each row in the spreadsheet represents a different project (with its
relevant information).

I have designed a macro that allows the user to move the project (row) from
the Arrivals tab to the Departures tab. All it does copy the entire row, move
to the Departures tab and paste the row at row 12 (moving all the other rows
down).

It was working fine.... until I put a few lines of code in to track changes
that a user makes to the spreadsheet. Below is the code -

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not Application.Intersect(Range("a1:az2000"), Target) Is Nothing Then
Target.Cells.Interior.ColorIndex = 55
End If
End Sub

(This code is in the Sheet 1 section of the code window.)

Now when i run the macro is shows and error saying - PasteSpecial Method of
Range Class Failed. Apparently this means that the macro is thinking that it
has nothing to paste....
The macro still works - and carries over the project info - but I can't get
rid of the error message.

Any help would be great.

Cheers,
Phil