Paste disabled

**lushl0sn** · 11-08-2007, 03:16 PM

Hi Folks

I've got a problem that i've been unable to solve.
I've got Data Validation used on one of my columns.
The list of values come from a named range on another sheet.
The problem is if you select a value from the dropdown, you can't paste that value into other cells below it. The paste choice is grayed out!
Any help is appreciated!

Thanks in Advance!

**Leith Ross** · 11-09-2007, 12:26 AM

Hello lushl0sn,

Welcome to the Forum. It would be easier and faster to find the cause of your problem if you would zip your workbook, and attach it to your next post.

Thanks,
Leith Ross

**shg** · 11-09-2007, 01:16 AM

Sounds like the worksheet is protected.

**lushl0sn** · 11-09-2007, 11:48 AM

I have narrowed it down to the following bit of code!

 Private Sub Worksheet_SelectionChange(ByVal Target As Range)

For Each cell In Range("F5:F1000")
If cell > "" Then
cell.EntireRow.Interior.ColorIndex = 6  
Else
cell.EntireRow.Interior.ColorIndex = xlNone
End If

Next cell

End Sub

If (cell.EntireRow.Interior.ColorIndex = 6) and ('cell.EntireRow.Interior.ColorIndex = xlNone) are removed, then Paste works!

Can anyone tell me what is going on and how to fix it?

Here iis an example
sample4.zip