VBA: Paste from Clipboard to Active Cell (then TAB key)

[zero269]

Hello,

I'm having trouble pasting from the Windows Clipboard into the Active Cell in Excel.

I've tried a few variations online but none of them work.

The one that looks like the simplest is:

Sub PasteValues()
ActiveSheet.PasteSpecial Paste:=xlPasteValues
End Sub

However, this throws a run-time error '1004'

NOTE: I'm copying a value from a web page and trying to just Paste it into the active cell.
I'd like to Tab (key) which should move to the next row in my case within the Table.

Microsoft's information on Worksheet.Paste method is not very helpful. Their EXAMPLE:

Worksheets("Sheet1").Range("C1:C5").Copy
ActiveSheet.Paste Destination:=Worksheets("Sheet1").Range("D1:D5")

I'm not using their COPY line because I'm trying to PASTE from the Clipboard, and they indicate the Destination is optional and that it defaults to the active selection.

Thank you...

 

[zero269]

Haha, well this is a "feeder" sheet for me. I am trying to copy data from a table on a website to ActiveCell A2 where it will create multiple worksheets based on values in column H and copy/paste the relevant rows to each worksheet. There's always more than one way to do something so hopefully somebody comes along to enlighten us

Not sure if this will help you specifically, but worth testing out perhaps...

VBA: Paste from Clipboard to Active Cell (then TAB key)

Hello, I'm having trouble pasting from the Windows Clipboard into the Active Cell in Excel. I've tried a few variations online but none of them work. The one that looks like the simplest is: Sub PasteValues() ActiveSheet.PasteSpecial Paste:=xlPasteValues End Sub However, this throws a...

www.mrexcel.com