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

Copy/paste range without resizeing cells
 

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

--
Regards,
Tom Ogilvy


"konpego" wrote in message
...
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

Copy/paste range without resizeing cells
 

"?B?a29ucGVnbw==?=" wrote in message ...
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