Posted to microsoft.public.excel.programming

Steve[_4_] Steve[_4_] is offline

external usenet poster

Posts: 184

Copy Column Width

Hello. I'm copying a range of cells with the code below to a different worksheet. How can I modify the code to also copy over the column widths from the source page? Thanks!

With wksSource
.Columns("K:K").AutoFilter Field:=1, Criteria1:="Y"
.UsedRange.Copy wksTarget.Rows("1:1")
.Columns("K:K").AutoFilter
End With

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
Can I copy row height like i copy column width?	Markman	Excel Discussion (Misc queries)	1	April 3rd 09 01:54 AM
Copy Column width	robert morris	Excel Discussion (Misc queries)	3	October 13th 07 04:28 PM
Create a macro which takes a column name and width and sets the column width to what it should be	Ag	Excel Programming	4	September 29th 07 11:29 PM
Copy column width along with data??	JR Hester	Excel Discussion (Misc queries)	4	September 20th 07 09:06 PM
copy paste (column width prb)	Murat D. Hekimoðlu	Excel Programming	2	May 12th 05 03:31 PM

All times are GMT +1. The time now is 01:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us