Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #108896

Re: Modify Code to loop back through table after its been updated and process it

Show key headers only | View raw

'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

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Modify Code to loop back through table after its been updated and process it TimLeonard <TimLeonard.119a37a8@excelbanter.com> - 2016-06-05 20:21 +0100
  Re: Modify Code to loop back through table after its been updated and process it GS <gs@v.invalid> - 2016-06-05 20:06 -0400
    Re: Modify Code to loop back through table after its been updated and process it TimLeonard <TimLeonard.119b6d08@excelbanter.com> - 2016-06-06 18:27 +0100
      Re: Modify Code to loop back through table after its been updated and process it GS <gs@v.invalid> - 2016-06-06 14:42 -0400
        Re: Modify Code to loop back through table after its been updated and process it TimLeonard <TimLeonard.119bc168@excelbanter.com> - 2016-06-06 23:54 +0100
          Re: Modify Code to loop back through table after its been updated and process it GS <gs@v.invalid> - 2016-06-06 23:41 -0400
          Re: Modify Code to loop back through table after its been updated and process it GS <gs@v.invalid> - 2016-06-07 12:42 -0400
            Re: Modify Code to loop back through table after its been updated and process it TimLeonard <TimLeonard.119d5938@excelbanter.com> - 2016-06-08 05:34 +0100
              Re: Modify Code to loop back through table after its been updated and process it GS <gs@v.invalid> - 2016-06-08 03:46 -0400
              Re: Modify Code to loop back through table after its been updated and process it GS <gs@v.invalid> - 2016-06-08 13:45 -0400
                Re: Modify Code to loop back through table after its been updated and process it GS <gs@v.invalid> - 2016-06-08 13:55 -0400
                Re: Modify Code to loop back through table after its been updated and process it TimLeonard <TimLeonard.119e8e98@excelbanter.com> - 2016-06-09 03:45 +0100

csiph-web