Find element of my macro is not working

Hello,

The following macro is not working as it states "Object variable or With block variable not set

The macro is below. It is showing the error on the

Please Login or Register  to view this content.

Here is the macro in whole:

Please Login or Register  to view this content.

Thank You

You need to declare an object variable

Please Login or Register  to view this content.

This works thank you

However i am now getting "Run-time error '1004' on the following line of the macro

Please Login or Register  to view this content.

here is the code in whole

Please Login or Register  to view this content.

You will get many errors as the code you have is a recorded macro.
You have used the property "Selection" lots of time. This is prone to errors.
Please attach the sample to see how to change the code.

apologies for the delayed response

Attached is the sample workbook

SAMPLE.xls

Please explain what do you want to do once the code finds delivery dat in sheet All Parts?

I want it to cut the delivery date row and place it in column A, moving the material column to the right. This will allow the formulas in the table on the charts sheet to populate the total number of parts in each year. The unsourced list may change each month meaning delivery date will not always be in the same column which is why the macro has to find the delivery date instead of cutting a particular column.

I want the table on the Charts sheet to automatically update which creates the chart below it. The last piece of data will move to the above row which will allow the chart to show a trend in the improvements made over tha past 8 weeks.

I have not looked at the rest of the code, but the first top bit of the code works.

This works perfectly now, thank you!