View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dmexcel dmexcel is offline
external usenet poster
 
Posts: 20
Default calling a function

I am having problems with my find match function in VBA, this workbook
is linked to another workbook, and the reference cells come from that
workbook, this doesn't always calculate because there has been no event
that triggers the calculation,
Right now I have a macro that goes back to that work book and rewrites
a formula in one of the cells just to trigger the calculation, is there
a more efficient way to do this?