Anyone know the syntax for accessing all formulas in a sheet. I have a sheet full of look up formulas that relies on a data range within a spearate file. That separate file is always named by date. I want access all the formulas and swap the existing date with a new date. I willl more than likely add a control of some sort that captures the the date the user wants and then assign the input to a variable swap in plae of the current date variable.
No problem on the swap routine...just need to know how to access the formulas.
Thanks
No problem on the swap routine...just need to know how to access the formulas.
Thanks