VBA clarification

Brass Contributor

I have yet another question regarding a macro on the spreadsheet that I translated from French to English. I was wondering if someone could tell me what "nb" means in this code; I've also provided the original French code in case that helps!


Screenshot 2023-04-02 085737.pngScreenshot 2023-04-02 085757.png

2 Replies


nb_ligne_a_inserer is the name of a variable. It is not strictly necessary to translate it.

Nb is short for nombre = number, so you can keep it, but you have to be consistent.

The highlighted name is nb_row_a_inserer, but in the next line you use nb_row_to_insert. Use the latter.

Thank you! I'm VERY new to VBA coding if you couldn't tell