View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
konpego konpego is offline
external usenet poster
 
Posts: 7
Default Copy/paste range without resizeing cells

Hello,

I want to copy cell data (presented as a table with 10 rows and 3 cols) from
one WB to another.
The problem is that the cell sizes differs between the two tables.
When pasting the range into the receiving table I want to keep the
cell-sizes in the receiving table.
How do I accomplish this?
Today I use:

Range("F34:N44").Select
Selection.Copy
....
ActiveSheet.Paste

Ideas someone?

/konpego