How to select first blank cell in specific column in next sheet?

[Tardisgx]

[FONT=&quot]https://imgur.com/a/2ejmwWa[/FONT]
[FONT=&quot]I have something copied on my clipboard and I want to select sheet 2 row F (first blank cell)[/FONT]
[FONT=&quot]and I have the pasting code ready but I can't fix the in-between despite searching forums such as this one.[/FONT]
[FONT=&quot]The first picture starts at the copy action. after copy I try to select the other sheet and perform the above^[/FONT]
[FONT=&quot]The second picture is the whole macro.

The code to find the first blank cell in f is a mess now after different iterations; ignore it. [/FONT]

 

[dreid1011]

The problem is here:

.End(xlUp)

You have it as .End(x1Up), it should be .End(xlUp). It should be a lowercase "L" in "xlUp", not a 1.

 

[Tardisgx]

https://imgur.com/a/9djRKmv

I don't know what the issue is?

 

[My Aswer Is This]

Why not post your code here and not as a image. If you look around the forum you will see most people post their code here.

 

[Tardisgx]

Sub Nomatchfinder()
'
' Nomatchfinder Macro
'


'
Cells.Select
Application.CutCopyMode = False
Selection.AutoFilter
ActiveSheet.Range("$A$1:$E$24112").AutoFilter Field:=4, Criteria1:= _
"Not Found"
Range("C2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Sheets("PPIDs here").Select
Range(Selection, Sheets("PPIDs here").Cells(Rows.Count, "F").End(xlUp).Offset(1)).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub

 

[Tardisgx]

Sub Nomatchfinder()
'
' Nomatchfinder Macro
'


'
Cells.Select
Application.CutCopyMode = False
Selection.AutoFilter
ActiveSheet.Range("$A$1:$E$24112").AutoFilter Field:=4, Criteria1:= _
"Not Found"
Range("C2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Sheets("PPIDs here").Range("F1").End(xlDown).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub

Does not work mthod of range class failed or object not defined