I am currently trying to create a macro that will only paste a specific date into the ADDRESS function result location.

I have used a LOOKUP function to find the column and row numbers then ADDRESS to give the cell reference of the correct location, the difficulty I am having is pasting to the correct location.

Any Ideas would be welcome.

thanks in advance