Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code for copying part of a sheet to another, with column widthsand formats
Hello,
I'm trying to take a range from one sheet(Range.cells(1,1),cells(10,10)) and copy it from sheet 1 to sheet 2. The copy is easy. But what I don't understand how to do is to carry over with the copy all of the column widths and numeric formats. Can someone please explain how this is done in VBA code? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying formats - column widths, formats, outlining to worksheets | Excel Worksheet Functions | |||
Copying rows values on one sheet to part of a formula in a column | Excel Discussion (Misc queries) | |||
Copying Part of a row down part of a column | Excel Discussion (Misc queries) | |||
copying conditional formats to a whole column | Excel Worksheet Functions | |||
Copying formulas, formats, and sheet names across workbooks | Excel Programming |