Custom Funtions

[jonc31]

I am really confused at this point. I created a custom function in vba that goes to another tab in the same workbook and grabs a correspoding number based off the statements in the function. The thing is when I intially enter the formula it is grabbing the correct data but if I update the tab the next day the formula is not updating with the new value.

How do you get custom functions to continually recalculate?

 

[MrKowz]

MrK, Looking at the UDF, Tabname!D:D would need to be INDIRECT("'"&Tabname&"'!D:D") or similar, likewise for the other instances of Tabname, defeating the object of trying to make a non-volatile formula.

What I supplied is not a UDF, it is a native excel formula solution. The TabName I indicated in the formula was merely a placeholder for where the true TabName should be placed. The ranges should be directly referenced in the formula.

 

[jasonb75]

What I supplied is not a UDF, it is a native excel formula solution. The TabName I indicated in the formula was merely a placeholder for where the true TabName should be placed. The ranges should be directly referenced in the formula.

That is perfectly obvious, I was refering to the OP's UDF, not your suggestion.

If you read the code and the description, it is suggested that Tabname is subject to change, so your native formula "solution" would mean editing the formula on a daily basis to change the Tabname instead of having a consistant formula that points to the source of the Tabname.

 

[MrKowz]

That is perfectly obvious, I was refering to the OP's UDF, not your suggestion.

If you read the code and the description, it is suggested that Tabname is subject to change, so your native formula "solution" would mean editing the formula on a daily basis to change the Tabname instead of having a consistant formula that points to the source of the Tabname.

Even so, using a UDF to loop through data to perform a dual condition lookup is incredibly ineffecient, especially as a volatile formula. Any time native formulas can be used, even volatile ones, it would be highly desired.

Jonc31, can you please clarify the purpose of this UDF, as well as what elements are subject to change?