I've written a short UDF with this line:

gUnit =
ThisWorkbook.Worksheets(sReportSheet).ChartObjects (sChartName).Chart.Axes(xlValue).MajorUnit

When I call the function from a small (27 kb) workbook I get this message:
"Excel cannot complete this task with available resources. Choose less data
or close other applications."

But when I replace that line with...

gUnit = .05

....I don't get the message. And with regard to resources, these problems
come after a reboot with only Excel open.

Additionally, when that line is included, I'm getting very frequent crashes.

Does anyone have any ideas about ways to get around these problems?

Thanks.

Charley