Thread: How to find “single cell result”of a relative defined name in a VBA code?
View Single Post
 
Old 07-25-2023, 07:52 PM
soroush.kalantari soroush.kalantari is offline Windows 10 Office 2016
Competent Performer
  
Join Date: Jun 2021
Posts: 124
soroush.kalantari is on a distinguished road
Default
Quote:
Originally Posted by Logit View Post
Where did you derive the vba formula :

t = Mid(Right(Selection.Formula, Len(Selection.Formula) - 1), 1, 5)
I have written this formula simply such that to get “price” from it. As I mentioned, my question is not: how to separate a relative name from a formula? but it is: given a relative name of an active cell formula in a vba code, is there some line of code to get “singe cell result address” of this relative name( here the price)?
Reply With Quote