Replies

Thanks Hans that worked just perfect!

I originally thought that the problem may have been caused by a protection error but it turns out that the problem was that I was using the cell as the control source for one of my user forms.

Thanks for your suggestion it set me on the right path to the problem.

Interesting – when I copy just the one sheet and remove any links to the original workbook the problem goes away. I am only referencing the one sheet with my formula.

This is a workbook that is sent out to various individuals. I would like to create a link in the worksheet that automaticaly emails the workbook back to me after they have filed out their information.

This is a workbook that is sent out to various individuals. I would like to create a link in the worksheet that automaticaly emails the workbook back to me after they have filed out their information.

Thanks I will watch out for that possiblity.

I gave it one more try and it worked this time (??). Thanks for persevering.

I have tried several version of an IS formula including the one you suggested. They work if I place them in another cell then reference the cell in my Formula Is but not if I place them directly in the Conditional Formatting for the cell.
Thanks

THANKS that works like a charm!

I am trying to use vlookup to gather the info needed for part of my Dget formula however; when I insert the value returned into my Dget formula the formula does not recognize the value (I end up with either #NA or #VALUE). If I type the value into the Dget formula it is just fine so the formula is written correctly. Is there a way to make this work or alternatively is there a way to write a macro that will piece together a range name (from data in two different cells) so that I can select and copy the approriate table to a fixed range. THANKS
formula in Cell A27 (to return name of table range)
=D8&G3
Formula in Cell B27 (to return square footage value which may not be exactly a number listed in the table)
=vlookup(C27,A27,1)
Formula in Cell B28) (to return value based on square footage and other elements)
=dget(A27,”Stone on Block”,B26:B27)

each formula works if the table range name is typed rather than using the A27 cell reference – A27 displays the correct range name