Results 1 to 9 of 9

Paste disabled

Threaded View

lushl0sn Paste disabled 11-08-2007, 03:16 PM
Leith Ross Hello lushl0sn, Welcome to... 11-09-2007, 12:26 AM
shg Sounds like the worksheet is... 11-09-2007, 01:16 AM
lushl0sn I have narrowed it down to... 11-09-2007, 11:48 AM
shg You forgot to tell us there... 11-09-2007, 11:53 AM
lushl0sn Sorry about that! It's in... 11-09-2007, 12:27 PM
Leith Ross Hello lushl0sn, I... 11-09-2007, 09:52 PM
mikerickson Couldn't those event routines... 11-09-2007, 10:08 PM
lushl0sn Thanks so much for the help... 11-11-2007, 11:02 AM
  1. #4
    Registered User
    Join Date
    10-31-2007
    Posts
    6
    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
    Last edited by VBA Noob; 11-09-2007 at 12:54 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1