question

balaram-0618 avatar image
0 Votes"
balaram-0618 asked

VBA Code to transfer cell format without copy paste

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

office-vba-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers