I want to copy the contents of the cell above to the active cell below

[LeapingLizard]

Hello,

I would like to copy what's in the range of cells above (F3:E46) to the active cell below. What am I doing wrong? Here is the code I used;

Please Login or Register  to view this content.

Thanks,

[MarvinP]

You need something after the <> in the statement of:

Please Login or Register  to view this content.

[LeapingLizard]

What would that be? I am drawing a blank.

[Damien-ebd]

You should try avoiding selecting cells you are copying if you know the range because the active cell will be the cells selected. Why not try an approach like this:
Range("F3:E46").Offset(-1, 0).Copy
ActiveCell.PasteSpecial (xlPasteValues)

[JOHN H. DAVIS]

Maybe?

Please Login or Register  to view this content.

[LeapingLizard]

Well, I have given the above code a whirl in the included spreadsheet, but it did not do what I wanted it to. So, if I you look at E10:F10, if I want to copy what is in these cells to E11:F11 instead of wasting the key strokes what must I do?


Thanks!

LeapingLizard

[JOHN H. DAVIS]

Maybe?

Please Login or Register  to view this content.

[LeapingLizard]

Beautiful! Thanks John!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please mark this thread as SOLVED if that takes care of your problem.