Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA to format paint cell(s)
Is it possible to make the formatting of a target cell the same as some
source cell - like through the use of the toolbar "format painter"? If not what's the best way to go about replicating formatting from one cell to another? Thanks in advance for any ideas you have. Charles |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA to format paint cell(s)
It can be, but why not just use the format painter?
-- HTH Bob Phillips " wrote in message ... Is it possible to make the formatting of a target cell the same as some source cell - like through the use of the toolbar "format painter"? If not what's the best way to go about replicating formatting from one cell to another? Thanks in advance for any ideas you have. Charles |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA to format paint cell(s)
Among many other things I'm programatically adding values to cells in some
worksheets that need to match existing formatting... "Bob Phillips" wrote: It can be, but why not just use the format painter? -- HTH Bob Phillips " wrote in message ... Is it possible to make the formatting of a target cell the same as some source cell - like through the use of the toolbar "format painter"? If not what's the best way to go about replicating formatting from one cell to another? Thanks in advance for any ideas you have. Charles |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use VBA to format paint cell(s)
Record a macro when you do Edit|copy, edit|paste special|Formats
And you'll see the code you'd use. wrote: Among many other things I'm programatically adding values to cells in some worksheets that need to match existing formatting... "Bob Phillips" wrote: It can be, but why not just use the format painter? -- HTH Bob Phillips " wrote in message ... Is it possible to make the formatting of a target cell the same as some source cell - like through the use of the toolbar "format painter"? If not what's the best way to go about replicating formatting from one cell to another? Thanks in advance for any ideas you have. Charles -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy a picture from Paint to a specific cell in Excel? | Excel Discussion (Misc queries) | |||
Need conditional statement to paint a cell | Excel Discussion (Misc queries) | |||
Need conditional statement to paint a cell | Excel Worksheet Functions | |||
can you tell me how to embed a pic for paint into an excel cell | Excel Worksheet Functions | |||
Need Help With Format paint | Excel Discussion (Misc queries) |