Hi,

.Range("B" & f.Row).Resize(6, 24).Value = wb.Sheets("Rides").Range("J38:AG43").Value
It is part of my macro which copy only the value of a range of data. How to rewrite it to copy both the value and format, including conditional format of this range of data?