Path: csiph.com!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!border2.nntp.dca1.giganews.com!Xl.tags.giganews.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!local2.nntp.dca.giganews.com!nntp.newsgroupbanter.com!news.newsgroupbanter.com.POSTED!not-for-mail NNTP-Posting-Date: Mon, 06 Jun 2016 18:49:03 -0500 From: TimLeonard Newsgroups: microsoft.public.excel.programming Subject: Re: Modify Code to loop back through table after its been updated and process it Date: Mon, 6 Jun 2016 23:54:49 +0100 Message-ID: Organization: ExcelBanter.com User-Agent: X-Newsreader: X-Originating-IP: References: Lines: 35 X-Usenet-Provider: http://www.giganews.com X-Trace: sv3-C4knJ+6q8tFtyiWMXccCQNHvwL2OZtO09KV8pVZUOeGKdjKRhMCAGH6OO4yoJuJz1+x5KWLd6eztERW!EKoI14KAWkSrRMJyMmjU/lC8MF9sxdx10O7fYDWVfz4621v4TOWirPVV1z4aGYP7YrLh77JQ+HzY!kQOHPjkbliVJ X-Complaints-To: abuse@newsgroupbanter.com X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.40 X-Original-Lines: 19 X-Original-Bytes: 2364 Xref: csiph.com microsoft.public.excel.programming:108896 'GS[_6_ Wrote: > ;1623706'] > Just a FYI.., row/col indices are Long type NOT Integer! > Noted, I changed it > > 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.php?t=450775&highlight=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... > > 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... -- TimLeonard