formula error

M

mlm

Actualy more of a note.
THis one says that i have a formula that includes a range
with cells that contain data adjacent to it. I have those
green tabs in the corner of all the cells. there are alot
but dont need to adjust cells. is there a way to have
them all ignored each time i open the book? I could add a
extra column but hten it would throw off my user form
macro for searching..

ideas?

thanks mike
 
G

Gord Dibben

mike

You could go to Tools>Options>Error Checking and uncheck one or more of the
"rules" options you find there.

Or turn off Enable Enable Error Checking totally.

Gord Dibben Excel MVP
 
M

mlm

thank you!
-----Original Message-----
mike

You could go to Tools>Options>Error Checking and uncheck one or more of the
"rules" options you find there.

Or turn off Enable Enable Error Checking totally.

Gord Dibben Excel MVP
Click to expand...
 
Top