| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
If I use .Value as below, I can copy the column's values.
wks_SR.Columns("D  ").ValueI would like to copy the whole column including the formating. Does anyone know what I should use instead of .Value? Thanks Simon |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
I have solved the problem as below:
wks_SR.Columns("D ").Copy wks_Orders.Columns(last_col + 1)>-----Original Message----- >If I use .Value as below, I can copy the column's values. > >wks_SR.Columns("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 > >. > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Copy and paste?
Record a macro when you copy|paste special|values, followed by copy|paste special|formats and you'll have the code. Simon wrote: > > If I use .Value as below, I can copy the column's values. > > wks_SR.Columns("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 -- Dave Peterson (E-Mail Removed) |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| list box date column, number column formating | =?Utf-8?B?R2Vvcmdl?= | Microsoft Access Form Coding | 2 | 16th Mar 2007 01:03 PM |
| Re.Incl/Do Not Incl the orig.msge. | =?Utf-8?B?TWljaGFlbGljYWw=?= | Microsoft Outlook Discussion | 0 | 10th Jul 2006 11:37 AM |
| Combo Box - auto complete and the bound column/text column propert | =?Utf-8?B?amVmZmJlcnQ=?= | Microsoft Excel Programming | 3 | 29th Jun 2006 10:31 PM |
| Vlookup did cell auto formating but not displaying complete text.. | =?Utf-8?B?Um9kYQ==?= | Microsoft Excel Worksheet Functions | 2 | 27th Dec 2004 02:27 PM |
| Copying formating and function from one Column to another | poppy | Microsoft Excel Programming | 2 | 19th Jul 2004 11:13 AM |
