Copy/paste range without resizeing cells

[Guest]

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

 

[Tom Ogilvy]

Range("F34:N44").Select
Selection.Copy
....
Activecell.Select
ActiveSheet.PasteSpecial xlValues

 

[David Fam?]

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

Just use:

"ActiveSheet.PasteSpecial(xlPasteAll)"

and not only ".Paste"

Bye,
David