ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Counter Failure (https://www.excelbanter.com/excel-programming/321295-counter-failure.html)

Arturo

Counter Failure
 
I have a master file that reside in a folder with a series of text files.
The text files are looped through generating, say one summed result each.
The summed results cell reference has a named range rt1Np. While looping
through the text files, rt1Np_cntr initially set to 0 is being re-set to
itself + the next rt1Np. rt1Np_Cntr = rt1Np_Cntr + rt1Np is not working and
I am not finding the pieces needed hold this running total.

Appreciatively,
Arturo

Tim Williams

Counter Failure
 
It's quite difficult to guess what the problem might be if you only
describe what is *supposed* to happen ;-)

Can you show some code ?

Tim.


"Arturo" wrote in message
...
I have a master file that reside in a folder with a series of text
files.
The text files are looped through generating, say one summed result
each.
The summed result's cell reference has a named range rt1Np. While
looping
through the text files, rt1Np_cntr initially set to 0 is being
re-set to
itself + the next rt1Np. rt1Np_Cntr = rt1Np_Cntr + rt1Np is not
working and
I am not finding the pieces needed hold this running total.

Appreciatively,
Arturo





All times are GMT +1. The time now is 12:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com