Tuesday, February 2, 2016

Copying The Values To The Other Page

Useful Macros – 11
Copying The Chosen Values To The Other Page

            This template is similar to the example in previous tutorial (Useful Macros-10).
Difference between two example; chosen data  are just copied (data aren't cut) in this template.

Also in this template , font color of the data in the Column C was selected red :
"For k = 2 To ActiveSheet.Range("C" & Rows.Count).End(xlUp).Row
       sh2.Cells(k, 3).Font.ColorIndex = 3
Next "