Paste values copied from a webpage

[robws8743]

I want to write a macro where I go to a webpage, copy two rows of six values, return to my worksheet and paste those values into and area where I make several calculations. I then want to copy and paste the results of the calculations into a cell adjacent to an item in one of three lists on the worksheet. My macro will paste the data but then halt with an error saying the paste special failed. I appreciate any help you can offer... I'm a novice at this but can see the power.
Tks

[werafa]

use the macro recorder - then edit your code heavily.
test your code regularly and back-track if it breaks.
then search on the code you don't understand and you'll find lots of commentary on how to improve the recorded code.

[snb]

Please post the code you have so far.

[werafa]

Sub PasteHeatmap()
    ' PasteHeatmap Macro
    On Error GoTo ErrorTrap
    With ActiveSheet
        .AutoFilterMode = False
        .Cells(1, 1).Activate
        .Cells.ClearContents
        .Cells(1, 1).Select
        .PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:=False
        .UsedRange
    End With
    Exit Sub
ErrorTrap:
    MsgBox "Did you remember to hit 'copy'?"
End Sub

Activesheet is important here - I never use it willingly

[werafa]

activesheet.usedrange is a handy trick to reset the used range property