View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kfell kfell is offline
external usenet poster
 
Posts: 9
Default vlookup doesn't update / recalculate

I have a cell containing a VLookup that doesn't contain the correct value
If I click on the cell and then click to edit the function and push enter it
updates to show the correct value.
How can I get a macro to force the cells to update so they show the correct
value?