have ported great deal of vba code from Excel 2003 to Excel 2007. I am
happy to say that most things worked, even things I thought would not.
However, one issue has stumped me. I have some worksheets that have
slidebars to change some values which in turn feed into the lookup_value and
reference for Hlookup, Vlookup, and Offset functions, respectively. However,
with autocalculation set to manual, Vlookup, Hlookup, and Offset functions
are not recalculating when a me.calculate is issued via vba code in the
worksheet module. This code works perfectly in Excel 2003. Does anyone know
why these worksheet functions are not updating and what can be done to make
them work in Excel 2007?