effiency in writing to shapesheet

[Robert]

hi,

is it more efficient to update say just one cell in a
section by iterating through each row in the section to
find the row, OR, should i be looking at using
SetFormulas to do this? (bearing in mind that it is just
ONE cell i am updating)

many thanks
j

 

[Mark Nelson [MS]]

Often SetFormulas or GetFormulas will be faster than working with Cell
objects even if you are only dealing with a single cell. These methods
access Visio in the same way that the information is stored internally,
while the Cell object is a more virtual representation of information that
incurs a bit of overhead to make available.