ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy format of a referenced cell (https://www.excelbanter.com/excel-programming/337647-copy-format-referenced-cell.html)

Mike[_95_]

Copy format of a referenced cell
 

I have code that sets the value of a cell to a referenced cell whose
name is in FilterAttributeName.

Workbooks(WorkWkb).Worksheets("work").Cells(Target Row, "E").Formula = _
"=" & FilterAttributeName

I now want Cells(TargetRow, "E") to have the same format as the
referenced cell. What is the easiest way to do this?

--Thank you,
--Mike Jr.



All times are GMT +1. The time now is 07:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com