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
|