Problem copying a 2D range from one sheet to another

[dschmitt]

Assume the following.
There is a 2D range of numbers from A1 to LastRow and LastColumn in sheet1.

LastRow and LastColumn are determined as follows:

Please Login or Register  to view this content.

How does the code looks like that copies this range to sheet2?

[pike]

Hi dschmitt

one way with the code you have is

Please Login or Register  to view this content.

[dschmitt]

thanks pike. One more question.
Some columns contain functions.
How do I need to modify your code if I only want to copy the values?

[pike]

Hi dschmitt
Try this....

Please Login or Register  to view this content.

[dschmitt]

thanks pike. I got it to work and learned 2 new ways of programming (destination, .Range)