View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Copy column width along with data??

hi
paste special DOES include paste column widths. Row highth is not there so
you have half of what you want.
on the menu bar... editpaste specialpaste column widths.

regards
FSt1


"JR Hester" wrote:

Is there any way to copy data from one shhet to another AND have the column
width/row hieght trasfer as well? I am accustomed to using paste special, but
this seem sNOT to include col width and row hieght.

Any way to accomplish without VBA?

Thanks