LinkBack URL
About LinkBacks
Hi,
can you help with transfer a formula from a cell into a VBA?
=IFERROR(IF($F25="";"";INDEX(Price!$D$2:$BI$131;MATCH(D25;Price!$B$2:$B$131;0);MATCH(F27;Price!$D$1:$BI$1;0)));"")
Hi,
can you help with transfer a formula from a cell into a VBA?
=IFERROR(IF($F25="";"";INDEX(Price!$D$2:$BI$131;MATCH(D25;Price!$B$2:$B$131;0);MATCH(F27;Price!$D$1:$BI$1;0)));"")
If the formula works in the cell, try doubling up all the double quotes. That is, "" becomes """".
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks, it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks