How Do I Paste Value?

From: rozb (anonymous_at_discussions.microsoft.com)
Date: 02/25/04


Date: Wed, 25 Feb 2004 12:36:07 -0800

Sub CheckSelectYes()
'selections are NOT necessary
Application.ScreenUpdating = False
For Each cell In Sheets("Select").Range("selectLanguage_Area")
    If cell.Value = "yes" Then Cells(cell.Row, 1).Copy 'somewhere??
    Next
    Application.ScreenUpdating = True
    End Sub