View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike[_95_] Mike[_95_] is offline
external usenet poster
 
Posts: 3
Default 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.