Hi Everyone,
I have a script here that dosen't appear to be copying from sheet3 and pasting into sheet2.
Can anyone see why this might not be working?
Thanks for the help!!!
Mike
![]()
Private Sub ComboBox1_Change() Dim r As Integer Dim R2 As Integer Dim c1 As Integer Dim c2 As Integer r = 113 + ComboBox1.ListIndex R2 = 141 + ComboBox1.ListIndex If r <> 76 Then c1 = 3 c2 = 5 Set source_range = Range(Cells(r, c1), Cells(r, c2)) Set source_range = Range(Cells(r, c1), Cells(r, c2)) Sheets(3).Select source_range.Copy Sheets(2).Select Set destination_range = Range(Cells(8, c1), Cells(8, c2)) destination_range.PasteSpecial xlValues 'Set source_range = Range(Cells(R2, c1), Cells(R2, c2)) 'Set destination_range = Range(Cells(54, c1), Cells(54, c2)) 'source_range.Copy 'destination_range.PasteSpecial xlValues End If Range("A30").Value = ComboBox1.Value With Range("A30") .Interior.ColorIndex = 3 End With Range("a13").Select End Sub











LinkBack URL
About LinkBacks
Register To Reply
Bookmarks