Help explaining code

**WasWodge** · 11-13-2010, 08:20 PM

If anyone can help I have a macro that isn't working correctly and i can't get in touch with the person that wrote it at this time. I think the problem lies in the full code below but there is a line in the code I don't understand. Can someone explain what the line

Please Login or Register  to view this content.

is telling the program to do? I think I grasp what the first part is saying but not the"+38 - 1" part.
Thanks in advance for any explanation

Please Login or Register  to view this content.

**TMS** · 11-13-2010, 08:27 PM

Think of it as in brackets:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

So, I'm not sure what s/he had in mind but that's looping through 37 rows of data starting at whatever value is in fRow. By default, the step between the to and from values is 1.

It might be to show whatever calculation was going on ... who knows?

Regards

**WasWodge** · 11-13-2010, 08:44 PM

That does actually make sense now I understand exactly what they have written as I know what they were afler. It would have made a bit more sense to you if I could have posted more code or the workbooks but I had to keep it to a bare minimum. I should be able to correct it from there. Thanks for your help.

**Leith Ross** · 11-13-2010, 09:38 PM

Hello paul555555,

On a side note, the one is subtracted from the 38 to include the first row in the count.

For example, if you want to loop form rows 1 to 5. If 5 is added to 1 the result is 6. Subtract 1 and the last row is 5. This works with number. If your first row is 2 and you want to loop to row 10 then 2 + 10 - 1 = 11.Counting from row 2 to 11 is 10 rows, inclusive.

**WasWodge** · 11-13-2010, 10:03 PM

Thanks for the further information, Leith. At least I can relay it to him what (AND WHY) I altered when I see him in a fortnight as I have it running correctly now.