| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copying complete column incl. formating
I have solved the problem as below:
wks_SR.Columns("D: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: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 . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copying complete column incl. formating
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: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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying conditional formating | Excel Discussion (Misc queries) | |||
| Conditional Formating copying (Max Min) | Excel Worksheet Functions | |||
| copying conditional formating | Excel Discussion (Misc queries) | |||
| Copying print formating | Excel Discussion (Misc queries) | |||
| Vlookup did cell auto formating but not displaying complete text.. | Excel Worksheet Functions | |||
Linear Mode
