application.caller
Thanks.
Is there a reliable way to get a value of calling cell? So the UDF can return that value under some circumstances. Cheers, Alex. "Tom Ogilvy" wrote: ? cvErr(xlErrRef) Error 2023 this is the same as the #Ref error I doubt it is caused by application caller, but more likely by the argument you are furnishing to the function. -- Regards, Tom Ogilvy "Alexander" wrote: Hi, Application.Caller in my UDF function is always Error 2023 (called due to the cell change). Why? Cheers, Alex. |
application.caller
set rng = Application.Caller
v = rng.Value will give you the value of the cell containing the formula (which is considered the calling cell). -- Regards, Tom Ogilvy "Alexander" wrote in message ... Thanks. Is there a reliable way to get a value of calling cell? So the UDF can return that value under some circumstances. Cheers, Alex. "Tom Ogilvy" wrote: ? cvErr(xlErrRef) Error 2023 this is the same as the #Ref error I doubt it is caused by application caller, but more likely by the argument you are furnishing to the function. -- Regards, Tom Ogilvy "Alexander" wrote: Hi, Application.Caller in my UDF function is always Error 2023 (called due to the cell change). Why? Cheers, Alex. |
application.caller
That results in a circular reference.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Tom Ogilvy" wrote in message ... set rng = Application.Caller v = rng.Value will give you the value of the cell containing the formula (which is considered the calling cell). -- Regards, Tom Ogilvy "Alexander" wrote in message ... Thanks. Is there a reliable way to get a value of calling cell? So the UDF can return that value under some circumstances. Cheers, Alex. "Tom Ogilvy" wrote: ? cvErr(xlErrRef) Error 2023 this is the same as the #Ref error I doubt it is caused by application caller, but more likely by the argument you are furnishing to the function. -- Regards, Tom Ogilvy "Alexander" wrote: Hi, Application.Caller in my UDF function is always Error 2023 (called due to the cell change). Why? Cheers, Alex. |
application.caller
Public Function Test()
Dim rng As Range Dim v As Variant Set rng = Application.Caller v = rng.Text Test = "A" & v End Function doesn't. -- regards, Tom Ogilvy "Chip Pearson" wrote in message ... That results in a circular reference. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Tom Ogilvy" wrote in message ... set rng = Application.Caller v = rng.Value will give you the value of the cell containing the formula (which is considered the calling cell). -- Regards, Tom Ogilvy "Alexander" wrote in message ... Thanks. Is there a reliable way to get a value of calling cell? So the UDF can return that value under some circumstances. Cheers, Alex. "Tom Ogilvy" wrote: ? cvErr(xlErrRef) Error 2023 this is the same as the #Ref error I doubt it is caused by application caller, but more likely by the argument you are furnishing to the function. -- Regards, Tom Ogilvy "Alexander" wrote: Hi, Application.Caller in my UDF function is always Error 2023 (called due to the cell change). Why? Cheers, Alex. |
All times are GMT +1. The time now is 12:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com