I am trying to apply cell format of Column(4) to other column in excel table without using copy paste option.
I am expecting code like below to transfer cell format
Range("B1:B5").Value = Range("A1:A5").Value
I tried the below code but it throws error
.ListObjects(1).Range.Resize(Rng.Rows.Count, 1).Cells.Format = .ListObjects(2).Range.Columns(4).Format
I really appreciate your quick help