View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter Rooney Peter Rooney is offline
external usenet poster
 
Posts: 325
Default MACRO HELP REQUIRED PLEASE!

Hi, Andy,

Why don't you just have your macro performing the copy and switch to
PointsList sheet?
Then, you could just click the cell you want and do [Control]-V or click the
Paste tool to paste your data in?
You have to click your target cell anyway, so one more click shouldn't make
much difference. Also, as your VBA improves, you'll see that you don't need
to GOTO a range in order to copy it (see below)

Sub Macro1()
Worksheets("Clipboard").Range("ahu1").copy
Sheets("Points List").activate
End Sub

Hope this helps

Pete