VBA - Pasting Values into Changing Cell

Hey Everyone,

I'm trying to create a table that updates via a macro using information input into a cell. The issue is that the data is added to the table based on the date, so the destination cell will change each day.

Here is the code I have (using named ranges). I think I am close, but I keep getting the "Unable to get the Match property of the WorksheetFunction class."

Please Login or Register  to view this content.

Thank you! I really appreciate any help or guidance!

-Ben

Hey there, thanks for the response.

I've simplified what I need the macro to do, but I'm still getting the same error regarding the MATCH function. I've uploaded a dummy workbook.

My code is:

Please Login or Register  to view this content.

Thank you!Delete Row Macro.xlsm

Thanks Leith,

That worked! I also had to change Dim ActualDate as Long (instead of as Date). Just curious if you have any idea why Long vs. Date would make it fail, since it is a Date in this case.

Thanks,
Ben

Thanks abousetta, that is helpful as well.