formula error
 

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

formula error
 

mike

You could go to ToolsOptionsError 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

On Mon, 23 Feb 2004 08:22:47 -0800, "mlm" wrote:

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

formula error
 

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

You could go to ToolsOptionsError 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

On Mon, 23 Feb 2004 08:22:47 -0800, "mlm"
wrote:

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

.