In a macro, I am copying data from another sheet and most of the time I only require the actual data or the values as per below.
But sometimes I want to also copy the Formats of the cell eg. color etc.![]()
.Offset(1, 0) = Worksheets("Main").Cells(7, 3).Value
How do I go about doing this please?
Bookmarks