formula error

  • Thread starter Thread starter mlm
  • Start date Start date
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
 
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
 
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...
 
Back
Top