Copying Cell Values

  • Thread starter Thread starter sunroyal
  • Start date Start date
S

sunroyal

Is there a way to have a value placed on the clipboard automatically
after the cell is populated?
 
Hi
put the following code in your worksheet módule. It will automatically
put the value of a cell entered in column A on the clipboard

Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Me.Range("A:A")) Is Nothing Then Exit Sub
With Target
If .Value <> "" Then
.Copy
End If
End With
End Sub
 
Back
Top