I am really not the expert here, but I wonder if you did what I always used
to do. That was to first select, via the VBA code, whatever I wanted to
copy. Which I soon found out I did not have to do.

It sounds like you are selecting a cell and then activating the procedure to
copy something from cell A600:D602, and then wanted that to be pasted
wherever you have selected.

If so, I think you could try this:

Range("A600:D602").Copy
Selection.Paste

I am sure the real gurus around here will have a better answer, but maybe
that will give you something to try until they answer.

Ken


"J.Reynolds" wrote in message
...
I am trying to insert some cells that I have formatted into a spreadsheet
at
a point where entries finish. This could be anywhere on the sheet. So
far I
have managed:- Range("A600:D602").Select
Selection.Copy
Range("..????")Select
Active Sheet Paste.
How can I tell the macro to enter my cells at the cell which I selected
without stipulating an actual cell?