Feel a bit silly for having to ask this but I somehow can't find the fix myself
Say I have a formula in sheet1 cell A1.
Now I want to get the "value" (by VBA of course...in normal excel its very simple) also lets say in sheet1 cell F11.
But the value in A1 can differ (by use of validations), so it should be a simple formula in F11 which references to every value A1 will get.
ps: I do not want to use the same formula as in A1 because it is a complez formula and I'm looking for the simple solution.
Bookmarks