#VALUE! Error

[VincentCrimmins]

Hi,

I have a spreadsheet in which I've created my functions.

There are about 6000 cells per sheet (over four sheets) that contain these four functions.

When I open the workbook, sometimes an entire sheet contains the #VALUE! error. Then I click into one cell, press return and they all fill out correctly, removing the errors. Is there away to remove this error?

Also, I've noticed three of my functions are in lowercase in the cell, yet in the VB code section they're in title case, is this significant?

Thanks!

 

[guitarzan]

This forum is for Visual Basic, not VBA. You should repost in forum707.