Find formula string in acad table

Anonymous — Fri, 21 May 2021 02:37:27 GMT

Hello,

I am trying to make schedules based on blocks. And I want total in the columns, which are fields.

What I have learnt is that I can not use SUM function for field values. I have attached a file in which SUM of field

is #### in electrical schedule. But in window schedule I can use SUM function in area and perimeter columns of fields. I dont know what is the difference between them.

So =SUM(C3:C4) does not work, but =C3+C4 works. Another way I came up is to insert a string "=C3+C4". This is not preferable but workable. The problem is that if I delete a row, formula gets ##..

Getcell value gets final value. What I want to do is find formula string and remove "ERR+" from it. so I can have

new clean foemula. There are so many properties of table. I tried many but could not get anything. There is getformula method which I cant see in Autocad 2007, which I am using.

Any help is appreciated.

regards

topic Find formula string in acad table in VBA Forum

Find formula string in acad table