Aug 5, 2004 #1 denko Programmer May 17, 2001 70 0 0 US Hello, Is there a way when copy or cut data from one Excel sheet into another to preserve the column width, data formats, and print layouts? Thanks
Hello, Is there a way when copy or cut data from one Excel sheet into another to preserve the column width, data formats, and print layouts? Thanks
Aug 6, 2004 #2 PHV MIS Nov 8, 2002 53,708 0 0 FR If you use the Copy method of the Worksheet object then all the formatting is preserved. Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244 Upvote 0 Downvote
If you use the Copy method of the Worksheet object then all the formatting is preserved. Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244