Copy Cells From One Sheet to Another...

[Bubbis Thedog]

I'm new to this board, so hello!

I need to copy A1:A2 in Sheet1, and paste the range transposed to Sheet2, in the first empty row. I also need to copy A4:B4 in Sheet1, and paste this range in Sheet2 such that it appears next to the transposed data. For example, Sheet2, row 1, would look like this after running the macro for the first time:

A1 | A2 | A4 | B4

Here's what I have thus far:

Please Login or Register  to view this content.

Now, it all posts to where it should in Sheet2; but I had formulas in A4 and B4 whose values are not reflecting??? The value from formulas from A1 and A2 paste fine, by the way. What am I doing wrong???

Bubbis Thedog