View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vinay Vinay is offline
external usenet poster
 
Posts: 8
Default How to make custom functions (VBA) read changes automatically?

Kindly help me on this. I have a function (VBA) which automatically runs the
mundane checks for data in a given sheet and runs a VLOOKUP on that sheet.
This is specific to the financial model that I am building. But, the only
concern here is that, it doesnot recognise the value changes until I manually
go to each cell and say "F2" followed by an enter. Kindly help me with this