I would like to have function that can give intermediate value of cell formula, and not the actual formula
I got one such function named gfrv() at below given link http://groups.google.com/group/microsoft.public.excel.misc/browse_thr... but it does not work for ranges and some other functions like "IF". It gives formula instead of intermediate result in case of ranges. this formula uses regular expression for extracting values. I would like to know how this can be modded for working with ranges --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
