Paste Code no longer working

[JBruner79]

Hey everyone, I have a sheet, that we copy data from a website and then it gets pasted into the excel sheet.
I have plenty of lines to accept all the data, the rows that it gets pasted into are hidden except for the first row.

It was literally working 5 minutes ago on two different workbooks, and now i am getting a 400 error.

Any help is greatly appreciated.

Here is code that is used, it is attached to a button, so we select the cell, then click the button, its always worked fine until right now.


Sub PasteText()


ActiveSheet.PasteSpecial Format:="Text", Link:=False, _
DisplayAsIcon:=False


End Sub

 

[JBruner79]

Hey everyone, I have a sheet, that we copy data from a website and then it gets pasted into the excel sheet.
I have plenty of lines to accept all the data, the rows that it gets pasted into are hidden except for the first row.

It was literally working 5 minutes ago on two different workbooks, and now i am getting a 400 error.

Any help is greatly appreciated.

Here is code that is used, it is attached to a button, so we select the cell, then click the button, its always worked fine until right now.


Sub PasteText()


ActiveSheet.PasteSpecial Format:="Text", Link:=False, _
DisplayAsIcon:=False


End Sub

NEVERMIND, i figured out that I was doing something wrong.