Hi All
Hope some can help with this problem.
I have the following formula in a spreadsheet:
=IF(ISERROR(IF(A4="","",VLOOKUP(A4,Structure!$A$2:$C$146,3,FALSE)))=TRUE,"",IF(A4="","",VLOOKUP(A4,Structure!$A$2:$C$146,3,FALSE)))
the formula works fine.
Now i have created a formula that manipulates data on a spreadsheet, but what i need is how to make a macro enter this formula into a cell.
If i can help it i would rather not have the formula on the spreadsheet and use it a 'Named Formula' are there any other ways?
Regards
Hope some can help with this problem.
I have the following formula in a spreadsheet:
=IF(ISERROR(IF(A4="","",VLOOKUP(A4,Structure!$A$2:$C$146,3,FALSE)))=TRUE,"",IF(A4="","",VLOOKUP(A4,Structure!$A$2:$C$146,3,FALSE)))
the formula works fine.
Now i have created a formula that manipulates data on a spreadsheet, but what i need is how to make a macro enter this formula into a cell.
If i can help it i would rather not have the formula on the spreadsheet and use it a 'Named Formula' are there any other ways?
Regards