In cell VBA function update (Excel 97)

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

Hi
I have a VBA function ChartTitle() that generates a title for a chart in an
excel spreadsheet. The title is generated depending of filtering selected
in an autofilter. At the moment I have a cell containing '=ChartTitle()'
which the actual chart title points to. Is it possible to ensure the
ChartTitle() function is run when the filtering changes, so the actual chart
title is updated?

TIA
Ben
 
Ben

If any calculations take place when the filter is applied then simply make
your function volatile with an opening line in it of

Application.Volatile True

This will force your function to recalc with all the other Excel functions

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top