How do you use ADDRESS function result in a macro as a paste destination

**phanjoe** · 09-04-2012, 07:13 AM

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

**TMS** · 09-04-2012, 07:50 AM

Maybe post the code and/or a sample workbook?

Regards, TMS

**phanjoe** · 09-04-2012, 12:40 PM

hopefully the attached will help to identify my problem.

**TMS** · 09-04-2012, 01:10 PM

There's no code in your sample book, although it is .xlsm file extension.

You use the function something like: =INDIRECT(ADDRESS(N5,O$5)) = INDIRECT(Address(5, 7)) = G5

You can't do a copy in an IF Function. You'd have to put the formula in the cell where you want the result.

Regards, TMS