Copy range incld. format (e.g.conditional formatting) from closed

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 36

Copy range incld. format (e.g.conditional formatting) from closed

Hi,

I'm trying to copy a range (including formulas, merged cells, conditional
formatting, column width etc) from a closed book into sheet2 of a workbook. I
tried Ron De Bruin's example, but it only copies the cells values from the
range. The range I'm copying is A1:AD113, and I need to copy this range into
sheet2 of a lot of workbooks in a folder so that it can automatically link to
values from sheet1. Please help, I appreciate any input.

Thanks,
Prash

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
conditional formatting - copy format & remove condition	Ladymuck	Excel Discussion (Misc queries)	1	March 2nd 10 10:18 AM
copy conditional formatting range	Steven Leuck	Excel Worksheet Functions	3	October 19th 09 07:21 PM
How to format range of cells using Conditional Formatting-Excel?	bookmanu3	Excel Worksheet Functions	2	June 14th 08 03:39 AM
copy conditional formatting, paste format without conditions	jasonr17	Excel Discussion (Misc queries)	6	May 2nd 08 05:52 PM
CopySpecialFormat: Not for Conditional Formatting?	Ingeniero1	Excel Discussion (Misc queries)	2	March 31st 06 03:28 PM

All times are GMT +1. The time now is 01:42 AM.

Menu

About Us