If I use .Value as below, I can copy the column's values.

wks_SR.Columns("D:D").Value

I would like to copy the whole column including the
formating.

Does anyone know what I should use instead of .Value?

Thanks

Simon