Delete lines with autfilter

[rpinxt]

Ok so I had a macro working just fine, but now I had to make some changes to it.
As a result now it crashes on another line of code with regards to delete certain rows after a autofilter has been applied.
This is the code now giving errors :
Sheet2.AutoFilter.Range.Offset(1, 0).Delete Shift:=xlUp (where are the quotes??)

It is caused by the offset part but did always work before.
Getting the appl-defined or object-defined error....

[Bernie Deitrick]

Replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

[rpinxt]

Thanks Bernie.
But unfortunately this generates the same error message.
While in debug the line with Offset gets highlighted in yellow

[Bernie Deitrick]

The code worked for me - is your sheet filtered? Protected? Do you have merged cells? Do you have an example workbook where the code fails?

[rpinxt]

Well yes my sheet is filtered as it is the filtered lines that I want to delete.
The code first copies these lines to another sheet and then needs to delete these lines from the source sheet.
Nothing protected and no merged cells.

It is a pretty big model which imports it data and then does several operations on the data.
So it is really not easy to share....

[Bernie Deitrick]

The "imports data" part - how do you import data?

What do you get with this line:

Please Login or Register  to view this content.

[rpinxt]

it gives A$:X$

Maybe helpful, only thing I changed in the code causing this problem was me changing a text to columns (to get numbers instead of text) with this:
With Sheet2.Range("U:U")
.NumberFormat = "General"
.Value = .Value
End With

[jolivanes]

Have a look at #3 in "Forum Rules" at the top about placing your code between code tags.
Show us all the code you have.

[Bernie Deitrick]

You cannot offset an entire column by one row - that is off the bottom of the sheet. You can either limit it to the used range:

Please Login or Register  to view this content.

or switch the offset and resize:

Please Login or Register  to view this content.