Hi,

I am using Offset formulas in Excel to create dynamic ranges and then
plotting a graph of those ranges. At times these dynamic ranges do not return
any results and that time i get following error message:-

A formula in this worksheet contains one or more invalid references.
Verify that your formula contain a valid path, workbook, range name and cell
reference

Is there a way to suppress this message? I tried using VBA statement
Application.displayalerts=False, but this doesn't work.

Thanks and Best Regards,

Vikas