View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jason jason is offline
external usenet poster
 
Posts: 39
Default Real simple VBA not sure why I cannot paste.

Here is the code i have. I have tried something with the cutcopymode with no luck. I can copy a cell, but I can't paste it anywhere. The cell I am trying to paste in is "D13", but it won't paste. Help!!!! Sometimes the most simplest is hard to see

Private Sub Worksheet_SelectionChange(ByVal Target As Range
Sheets("Casp Placements").Range("A3", "A138").Interior.ColorIndex =
Sheets("Casp Placements").Range("B3", "B138").Interior.ColorIndex = 4
Sheets("Casp Placements").Range("C3", "C138").Interior.ColorIndex = 3
Sheets("Casp Placements").Range("D3", "F138").Interior.ColorIndex =

End Sub