Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Formatting of Cell
Hi
not possible with formulas/user defined functions as they can only return values -- Regards Frank Kabel Frankfurt, Germany "WintonCW" schrieb im Newsbeitrag ... I am copying data from one sheet to another. I have used the =VLOOKUP () to find the data which is working nicely. However, is there any way to copy the formatting of the entire cell that I've found (ie -- background color)? I'm guessing I"ll have to write my own macro, so any help on this would be greatly appreciated. Thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Formatting of Cell
All right -- any suggestions for what to do? I'm pretty hesitant to copy each cell's characteristic individually as this is a sizeable -- and variable -- sheet.
Thank you |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Formatting of Cell
Hi
if you want to copy the formats for many cells you may have a look at 'Edit - Paste Special - Formats'. If this is not what you're looking for you may explain with some more detail how you ant to copy and if this is a one-time operation of if you want to change the formats automatically if the source formats changes -- Regards Frank Kabel Frankfurt, Germany "WintonCW" schrieb im Newsbeitrag ... All right -- any suggestions for what to do? I'm pretty hesitant to copy each cell's characteristic individually as this is a sizeable -- and variable -- sheet. Thank you |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Formatting of Cell
I ended up finally writing a macro that would do the trick:
'fromCell is found using a Cells.Find() 'toCell is assigned Sub Fill(fromCell, toCell) With toCell .Value = fromCell.Value .Interior.ColorIndex = fromCell.Interior.ColorIndex .Interior.Pattern = fromCell.Interior.Pattern End With End Sub *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel UDF copy cell with formatting | Excel Discussion (Misc queries) | |||
In a formula, copy the value and formatting of another cell | Excel Worksheet Functions | |||
Copy data to new cell but with different formatting | Excel Discussion (Misc queries) | |||
How do I copy formatting in a cell reference | Excel Discussion (Misc queries) | |||
Copy cell with individual formatting | Excel Programming |