View Single Post
  #5   Report Post  
TimLeonard TimLeonard is offline
Member
 
Posts: 46
Default

Quote:
Originally Posted by GS[_6_] View Post
Just a FYI.., row/col indices are Long type NOT Integer!
Noted, I changed it

Quote:
Your loops are confusing to say the least. I'd have to rewrite this
code so it's easier to read/understand. I'll post it back with
comments...
I don't know if it will help, but I had help a while back on a similar project. (http://excelbanter.com/showthread.ph...ghlight=Modify)
I have trouble following the logic in it and so I resort back to the original at times when doing test modifications since I am no programmer...
I now need to filter the Array1 to only attribute blocks that have addresses and couldn't figure out how to add it. Also I need to add the ability to send the revised attribute table back in to acad blocks which is ultimately what I am trying to code...

Quote:
Which loop in particular is not working?
Everything after the following doesn't update the attribute values.
"For n = LBound(newAttribs) To UBound(newAttribs)"
It seems to run through the "n" values fine but Doesn't update the respective .textstring. I have been trying the "blkEntity.Update" but it doesn't update and at some point it gives an error and closes...