Re: Shape Identity

Set the Formula = "="

"Barney" <peter.barnfield@xxxxxxxxx> wrote in message news:1190829688.231020.175850@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Thanks for this, David.

I installed SP3 and the problem is resolved. Thanks.

I'm very interested in what you say about passing "=" into cells, as I
have run into other recalculation problems before, so this could be a
universal "quick fix". However, I have tried to put a bit of VBA
together to do this, but seem to be stumbling at the very last part of
actually setting the Custom Property cell to the value "=". Is there
something I should know?

Thanks,
Pete.


.

Relevant Pages

  • Re: Shape Identity
    ... I installed SP3 and the problem is resolved. ... I'm very interested in what you say about passing "=" into cells, ... actually setting the Custom Property cell to the value "=". ...
    (microsoft.public.visio.developer)
  • Re: Ranges in Custom Functions
    ... Function Invt_Bal(Opening as Range, Purchases as Range) ... > Dim Counter As Integer, ... > fine when I was passing Names for the cells in, ...
    (microsoft.public.excel.programming)
  • Ranges in Custom Functions
    ... two cells rather than a cell name. ... Suppose in Excel I use: ... fine when I was passing Names for the cells in, ... Set Purchases = Range ...
    (microsoft.public.excel.programming)
  • Re: Complex conditional summing - array COUNT works, array SUM gives #VALUE
    ... You would normally have an arrangement like this: ... but you are not passing ... some complex conditional sums. ... without it, so it would seem all the selected cells are, in fact, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Laptops need to have HAZMAT fees
    ... Chances are that was a Li-ion battery. ... If it just short circuits, ... can cause the cells to get hot enough to vent hydrogen. ... passing over orange-hot leads isn't "compatable with safety". ...
    (rec.models.rockets)
Loading