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
|