View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.Reynolds J.Reynolds is offline
external usenet poster
 
Posts: 7
Default Insert cell anywhere

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?