How to delete the first part of sheet

[salvatore.quimi]

Hi everyone,

I have this type of sheet and I would like to delete the first part up to the table but sometimes the table starts at A27 others at A26 and so on.
How can I delete the first part if the beginning of the table always changes?

How can I do that?
Thanks in advance

[salvatore.quimi]

and I would the result like this:

[ImPratham45 (Prathamesh Patil)]

Use LookUp Range in that search for “Column1” output in variable as LookUP
It will give you the cell no say A27
Then assign Variable say Num=LookUP.Substring(1)
then use below code in Invoke VBA

Sub Macro2(LookUP)
Rows(“1:” & LookUP).Select
Selection.Delete Shift:=xlUp
End Sub

[supermanPunch (Arpan)]

@salvatore.quimi Check this workflow:
Remove Unwanted Rows.zip (7.7 KB)

Check the excel File First. Execute the Workflow. Check the Excel, the unwanted rows should be deleted.

[salvatore.quimi]

hi @ImPratham45 but if i use your code I immediately this error:

[ImPratham45 (Prathamesh Patil)]

what you have pass in Excel Application Scope file name?

[salvatore.quimi]

the path of my file excel

[ImPratham45 (Prathamesh Patil)]

Is it contains any variable?
Coz error says there is an field data which does not contains a value

[salvatore.quimi]

no, I did as your suggestion like this:

Maybe the Lookup activity is wong

[salvatore.quimi]

hi @supermanPunch I tried your method and it is fast and effective, thanks

[ImPratham45 (Prathamesh Patil)]

Check whether your lookup range gives a value or not by using Message box
If it not then u will get Object reference error