Posted to microsoft.public.excel.programming

external usenet poster

Posts: 287

Copying Formats vs Formatting Programatically

Can anyone speak to the performance issues between copying and pasting a
range of formats vs programmatically setting formats? It seems that it is
much faster to copy and paste, than looping through a range, and I am
wondering if anyone has any input on this.

We currently keep a template sheet, but I would like to move away from this.

Thanks in advance.

Regards,
Adam

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying formats - column widths, formats, outlining to worksheets	DavidBr318	Excel Worksheet Functions	4	August 14th 09 05:03 AM
Copying printer formats	ramona	Excel Discussion (Misc queries)	3	August 7th 09 03:45 PM
Copying Formats	JoeSpareBedroom	Excel Discussion (Misc queries)	9	February 7th 07 06:33 PM
Copying cell formats	Stu - Wast	Excel Worksheet Functions	5	August 10th 05 06:20 PM
Copying Cell Formats	Mark Schreiber	Excel Programming	2	December 20th 04 10:53 PM

All times are GMT +1. The time now is 08:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us