Simple qUestion

[Dolemitefunk]

I have a VBA code that is copying set range of cells from one worksheet and pasting them into another worshett. This code is working well, I just want to add one thing. I would like to highlight the cells that were pasted in so if someone else opens the file they know that those values were manually changed. So in short how do I have Excel Highlight a range of cells?

 

[VoG]

Post your code.

 

[Dolemitefunk]

Sub Autocopy()
Dim master As Workbook
Dim destOne As Worksheet
Dim lLastDestRow As Double
Set master = ActiveWorkbook
Set destOne = master.ActiveSheet
Set wbDest = Workbooks.Open("C:\Documents and Settings\AC08705\My Documents\Test2.xlsx")
Set wksDest = wbDest.Worksheets("Sheet1")
destOne.Range("C5:C66").Copy Destination:=wksDest.Range("H14:H75")
End Sub

 

[Dolemitefunk]

So, I would like to highlight range H17:H75....I just do not know the VBA code for it.

 

[VoG]

Try

[

Sub Autocopy()
Dim master As Workbook
Dim destOne As Worksheet
Dim lLastDestRow As Double
Set master = ActiveWorkbook
Set destOne = master.ActiveSheet
Set wbDest = Workbooks.Open("C:\Documents and Settings\AC08705\My Documents\Test2.xlsx")
Set wksDest = wbDest.Worksheets("Sheet1")
destOne.Range("C5:C66").Copy Destination:=wksDest.Range("H14:H75")
destOne.Range("C5:C66").interior.ColorIndex = 6
End Sub

 

[Dolemitefunk]

Excellent! Thank you so much, it worked!