carrying out calculations only for the no. of entries

Feb 19th, 2002, 06:47 AM

I am bassicly importing data which can be of difereing lenght, i have to do calculations on this data. At the moment i have recorded a macro which does a set number of calculations which is grether than the number of entries. I was wondering is their any way that you it could be set it up so that it only does the calcuations for the number of entries present and stops after this point.

Barrie Davidson · Feb 19th, 2002, 07:35 AM

Quote:

On 2002-02-19 05:47, Anonymous wrote:
I am bassicly importing data which can be of difereing lenght, i have to do calculations on this data. At the moment i have recorded a macro which does a set number of calculations which is grether than the number of entries. I was wondering is their any way that you it could be set it up so that it only does the calcuations for the number of entries present and stops after this point.

Post your macro code and I'll (or someone else will) help you clean it up.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 19th, 2002, 06:47 AM	#1
Guest Posts: n/a	I am bassicly importing data which can be of difereing lenght, i have to do calculations on this data. At the moment i have recorded a macro which does a set number of calculations which is grether than the number of entries. I was wondering is their any way that you it could be set it up so that it only does the calcuations for the number of entries present and stops after this point.