Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
keeping format of a referenced cell | Excel Discussion (Misc queries) | |||
How to apply same format of referenced cell in Excel | Excel Discussion (Misc queries) | |||
Applying number format from referenced cell | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) |