If just wanting values, another way is:
Hope that helps,ActiveSheet.Range("C" & Rows.Count).End(xlUp).Offset(1, 0).Resize(, Range("C8:O8").Columns.Count).Value = Range("C8:O8").Value
Mark
If just wanting values, another way is:
Hope that helps,ActiveSheet.Range("C" & Rows.Count).End(xlUp).Offset(1, 0).Resize(, Range("C8:O8").Columns.Count).Value = Range("C8:O8").Value
Mark
Posting Permissions
Reply With Quote