Posted to microsoft.public.excel.programming

simon

external usenet poster

Posts: 21

copying complete column incl. formating

If I use .Value as below, I can copy the column's values.

wks_SR.Columns("D:D").Value

I would like to copy the whole column including the
formating.

Does anyone know what I should use instead of .Value?

Thanks

Simon

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 conditional formating	Homero Noboa	Excel Discussion (Misc queries)	2	December 23rd 09 10:40 PM
Conditional Formating copying (Max Min)	Excelicious	Excel Worksheet Functions	3	April 3rd 08 06:47 PM
copying conditional formating	Jorge	Excel Discussion (Misc queries)	8	March 29th 07 01:41 PM
Copying print formating	jd	Excel Discussion (Misc queries)	4	February 7th 07 04:22 PM
Vlookup did cell auto formating but not displaying complete text..	Roda	Excel Worksheet Functions	2	December 27th 04 02:27 PM

All times are GMT +1. The time now is 03:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us